{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Budget Sheet Instructions","Demographics","Budget Detail - Year 1","Budget Detail - Year 2","Budget Detail - Year 3","Budget Detail - Year 4","Budget Detail - Year 5","Budget Summary","Admin","Reference Data","Example - Budget Detail Sheet","Definitions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":615,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budget Sheet Instructions","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[15,0,15,10],[16,0,16,10],[21,0,21,10],[14,0,14,10],[13,9,13,10],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[17,0,17,10],[18,0,18,10],[19,0,19,10],[20,0,20,10],[6,0,6,10],[11,0,11,10],[12,2,12,4],[0,0,0,10],[3,0,3,10],[7,0,7,10],[4,0,4,10],[8,0,8,10],[5,6,5,10],[5,0,5,4],[12,6,12,8],[9,0,10,10],[1,0,1,10],[2,0,2,10],[22,0,22,10],[23,0,23,10],[33,1,33,10],[31,1,31,10],[32,1,32,10],[30,1,30,10],[24,0,24,10],[29,1,29,10],[28,1,28,10],[25,1,25,10],[26,1,26,10],[27,1,27,10]]}
["Budget Detail Worksheet\nOMB Approval NO.: 1121-0329\nExpires 11/30/2020"]
["For a 508 compliant, accessible version of the Budget Detail Worksheet, use the following link:"]
["https://ojp.gov/funding/Apply/Forms/BudgetDetailWorksheet/BDW508.pdf"]
["Worksheet Instructions"]
["Note: This document requires macros be enabled to work properly. Please ensure that macros are enabled before entering any data. You may be able to enable macros by choosing the \"Enable this content\" option from the Security Warning Ribbon above. \n\n\n\n\n\nIf the ribbon is not visible you may have been prompted to enable macros when you opened the document as pictured here. If you elected to disable macros, "]
[null,null,null,null,null,null," please close the document and reopen it with macros enabled. "]
["Purpose:"]
["The Budget Detail Worksheet is provided for your use in the preparation of the budget and budget narrative. All required information (including the budget narrative) must be provided. Any category of expense not applicable to your budget may be left blank.  Indicate any non-federal (match) amount in the appropriate category, if applicable."]
["How to use this Workbook:"]
["The workbook includes several different worksheets. The first worksheet (this one) is an instruction sheet; the next worksheet includes the budget detail worksheet and narrative for year 1.  There are duplicates of this worksheet for years 2-5 that can be completed as necessary. The last worksheet is a Budget Summary. It compiles all of the relevant budget information  into a single location and should be reviewed for correctness before the workbook is uploaded to the GMS application. \nStep by Step Usage:\n1. Please read and print this instruction page. It can be used as a reference while completing the rest of the document.\n2. For each budget category, you can see a sample by viewing the 'Budget Detail Example Sheet'.\n3. The 'Definitions' tab explains terms used in the instructions for the various budget categories.\n4. Record Retention: In accordance with the requirements set forth in 2 CFR Part 200.333, all financial records, supporting documents, statistical records, and all other records pertinent to the award shall be retained by each organization for at least three years following the closure of the audit report covering the grant period.\n5. The information disclosed in this form is subject to the Freedom of Information Act under U.S.C. 55.2."]
[]
["Budget Point of Contact Information:"]
["Contact Name: ","Last:",null,null,null,"First: ",null,null,null,"Middle: "]
["Contact Phone: ",null,null,"Contact Fax:",null,null,null,"Contact Email:"]
["Worksheet Index:"]
["Tab"]
["Budget Detail - Year 1"]
["Budget Detail - Year 2"]
["Budget Detail - Year 3"]
["Budget Detail - Year 4"]
["Budget Detail - Year 5"]
["Budget Summary"]
["Example - Budget Detail Sheet"]
["Definitions"]
["Budget Category Descriptions:"]
["Personnel","List each position by title and name of employee, if available. Show the annual salary rate and the percentage of time to be devoted to the project. Compensation paid for employees engaged in grant activities must be consistent with that paid for similar work within the applicant organization. In the budget narrative, include a description of the responsibilities and duties of each position in relationship to fulfilling the project goals and objectives. All requested information must be included in the budget detail worksheet and budget narrative.\n"]
["Fringe Benefits","Fringe benefits should be based on actual known costs or an approved negotiated rate by a Federal agency. If not based on an approved negotiated rate, list the composition of the fringe benefit package. Fringe benefits are for the personnel listed in the budget category (A) and only for the percentage of time devoted to the project. All requested information must be included in the budget detail worksheet and budget narrative."]
["Travel","Itemize travel expenses of staff personnel (e.g. staff to training, field interviews, advisory group meeting, etc.). Describe the purpose of each travel expenditure in reference to the project objectives. Show the basis of computation (e.g., six people to 3-day training at $X airfare, $X lodging, $X subsistence). In training projects, travel and meals for trainees should be listed separately. Show the number of trainees and the unit costs involved. Identify the location of travel, if known; or if unknown, indicate \"location to be determined.\" Indicate whether applicant's formal written travel policy or the Federal Travel Regulations are followed. Note: Travel expenses for consultants should be included in the “Consultant Travel” data fields under the “Subawards (Subgrants)/Procurement Contracts” category."]
["Equipment","List non-expendable items that are to be purchased (Note: Organization's own capitalization policy for classification of equipment should be used). Expendable items should be included in the \"Supplies\" category. Applicants should analyze the cost benefits of purchasing versus leasing equipment, especially high cost items and those subject to rapid technological advances. Rented or leased equipment costs should be listed in the “Contracts” data fields under the “Subawards (Subgrants)/Procurement Contracts\" category. In the budget narrative, explain how the equipment is necessary for the success of the project, and describe the procurement method to be used. All requested information must be included in the budget detail worksheet and budget narrative."]
["Supplies","List items by type (office supplies, postage, training materials, copy paper, and expendable equipment items costing less than $5,000, such as books, hand held tape recorders) and show the basis for computation. Generally, supplies include any materials that are expendable or consumed during the course of the project. All requested information must be included in the budget detail worksheet and budget narrative."]
["Construction","Provide a description of the construction project and an estimate of the costs.   Minor repairs or renovations may be allowable and should be classified in the “Other” category. OJP does not currenly fund construction programs. Consult with the program office before budgeting funds in this category.  All requested information must be included in the budget detail worksheet and  budget narrative. "]
["Subawards (Subgrants), \nProcurement Contracts, &\nConsultant Fees","Subawards (see “Subaward” definition at 2 CFR 200.92):  Provide a description of the Federal award activities proposed to be carried out by any subrecipient and an estimate of the cost (include the cost per subrecipient, to the extent known prior to application submission).  For each subrecipient, enter the subrecipient entity name, if known.  Please indicate any subaward information included under budget category G. Subawards (Subgrants)/Procurement Contracts by including the label “(subaward)” with each subaward entry.\n\nProcurement contracts (see “Contract” definition at 2 CFR 200.22): Provide a description of the product or service to be procured by contract and an estimate of the cost.  Indicate whether the applicant’s formal, written Procurement Policy or the Federal Acquisition Regulation is followed.  Applicants are encouraged to promote free and open competition in awarding procurement contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold set in accordance with 41 U.S.C. 1908 (currently set at $150,000).\n\nConsultant Fees:  For each consultant enter the name, if known, service to be provided, hourly or daily fee (8-hour day), and estimated time on the project.  Consultant fees in excess of the DOJ grant-making component’s maximum rate for an 8-hour day (currently $650) require additional justification and prior approval from the respective DOJ grant-making component.  All requested information must be included in the budget detail worksheet and budget narrative.\n"]
["Other Costs","List items (e.g., rent, reproduction, telephone, janitorial or security services, and investigative or confidential funds) by type and the basis of the computation. For example, provide the square footage and the cost per square foot for rent, or provide a monthly rental cost and how many months to rent. All requested information must be included in the budget detail worksheet and budget narrative."]
["Indirect Costs","Indirect costs are allowed only if:  a) the applicant has a current, federally approved indirect cost rate; or b) the applicant is eligible to use and elects to use the “de minimis” indirect cost rate described in 2 C.F.R. 200.414(f).  (See paragraph D.1.b. in Appendix VII to Part 200—States and Local Government and Indian Tribe Indirect Cost Proposals for a description of entities that may not elect to use the “de minimis” rate.)  An applicant with a current, federally approved indirect cost rate must attach a  copy of the rate approval, (a fully-executed, negotiated agreement.  If the applicant does not have an approved rate, one can be requested by contacting the applicant’s cognizant Federal agency, which will review all documentation and approve a rate for the applicant organization, or if the applicant’s accounting system permits, costs may be allocated in the direct costs categories.  (Applicant Indian tribal governments, in particular, should review Appendix VII to Part 200—States and Local Government and Indian Tribe Indirect Cost Proposals regarding submission and documentation of indirect cost proposals.)  Narrative for any indirect costs should clearly state which direct costs the indirect cost agreement is being applied to.  All requested information must be included in the budget detail worksheet and budget narrative.\nIn order to use the “de minimis” indirect rate an applicant would need to attach written documentation to the application that advises DOJ of both the applicant’s eligibility (to use the “de minimis” rate) and its election. If the applicant elects the de minimis method, costs must be consistently charged as either indirect or direct costs, but may not be double charged or inconsistently charged as both. In addition, if this method is chosen then it must be used consistently for all federal awards until such time as the applicant entity chooses to negotiate a federally approved indirect cost rate.\n"]

{"sheet":"Demographics","index":1,"n_rows":164,"n_cols":9,"rows_kept":164,"cut":false,"hidden":true,"merged":[[102,5,102,6],[102,7,102,8],[104,2,105,6],[105,7,105,8],[126,2,126,6],[126,7,126,8],[115,1,115,8],[116,3,116,4],[117,3,117,4],[117,5,117,6],[117,7,117,8],[119,2,120,6],[120,7,120,8],[122,2,122,6],[122,7,122,8],[124,2,124,6],[124,7,124,8],[14,1,15,5],[14,7,14,8],[16,1,17,5],[16,7,16,8],[0,0,0,9],[1,1,1,8],[2,0,2,3],[3,1,3,8],[4,3,4,8],[6,3,6,8],[8,7,8,8],[12,1,13,5],[12,7,12,8],[10,1,11,5],[8,1,9,5],[10,7,10,8],[55,1,56,8],[58,0,58,3],[18,7,18,8],[22,1,22,8],[42,6,42,8],[45,1,46,8],[48,1,49,8],[50,1,51,8],[53,1,53,8],[54,1,54,8],[18,1,19,5],[20,1,21,5],[20,7,20,8],[163,7,163,8],[155,7,155,8],[156,7,156,8],[157,7,157,8],[158,7,158,8],[159,7,159,8],[160,7,160,8],[67,2,67,5],[67,6,67,8],[68,2,68,5],[68,6,68,8],[69,2,69,5],[69,6,69,8],[154,7,154,8],[94,5,94,8],[96,1,96,8],[97,2,97,8],[98,3,98,4],[98,5,98,6],[98,7,98,8],[136,1,137,8],[146,4,146,8],[148,4,148,8],[153,7,153,8],[89,5,89,8],[64,2,64,5],[64,6,64,8],[65,2,65,5],[65,6,65,8],[66,2,66,5],[66,6,66,8],[161,7,161,8],[162,7,162,8],[151,1,152,8],[100,1,100,8],[101,3,101,4],[92,1,92,8],[93,2,93,8],[71,1,71,8],[72,0,78,1],[113,7,113,8],[107,7,107,8],[109,2,109,6],[107,2,107,6],[109,7,109,8],[111,2,111,6],[111,7,111,8],[102,3,102,4],[59,1,59,8],[61,2,61,8],[62,2,62,5],[62,6,62,8],[63,2,63,5],[63,6,63,8],[72,2,78,8],[83,1,83,8],[84,1,84,8],[80,1,80,8]]}
["Demographic Form"]
[null,"Please fill out this form in its entirety. Note that each subsection has individual instructions. Please read them carefully before filling out this form. If you are applying as a consortium please aggregate the data for all the Tribes represented in your application."]
["I. Tribe Information"]
[null,"1. The name of each federally-recognized Indian Tribe that will be served by the proposed project(s):"]
[null,"Name(s)",null,"The name(s) of your tribe and represented tribes. "]
[]
[null,"BIA Region(s)"]
[]
[null,"2. What is the Tribe's current enrollment, including members living both on and off the reservation?"]
[]
[null,"3. What is the Tribe's juvenile population, including members living both on and off the reservation?"]
[]
[null,"4. Of your current enrollment, what is the Tribe's total number of unemployed 18 years and over?"]
[]
[null,"5. Of your current enrollment, what is the Tribe's total number of under-employed (below the poverty line) 18 years and over?"]
[]
[null,"6. Of your current enrollment, what is the Tribe's total number of employed 18 years and over?"]
[]
[null,"7. What is the current local population base?"]
[]
[null,"8. Please enter the approximate square mileage of the reservation/jurisdiction to be served: (sq. miles)"]
[]
[null,"9. Please check the crime victim population area(s) that best describe the services the Tribe typically supports."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"10. Have you applied for a CTAS grant before?"]
[]
[null,null,"If yes, what year?"]
[]
[null,"11. Please provide your status as an applicant (check all that apply):"]
[]
[]
[]
[]
[]
[]
[null,"a. If you selected Tribal Coalition or Tribal Consortia please list the tribes you represent:"]
[]
[]
[]
[null,"b. If you selected Non-profit organization describe the nature of you services and whom you provide them."]
[]
[]
[]
[]
[null,"12. Please indicate if you agree with the following statement: The tribe(s)submitting this application consider themselves to be remotely located with respect to availability of justice or other relevant community services."]
[null,"If you selected “Yes”, please provide a brief statement that explains your selection. Examples might include “For a majority of our tribal community, law enforcement resource centers are greater than 1 hour’s drive away.” Or  “Our tribal community has no resident medical facilities and the nearest public health center is operated by the City/Town of XXX which is not within tribal lands and not easily reached.”"]
[]
[]
[]
["II. Property/Violent Crime"]
[null,"Using the most recent available data and to the best of your ability using the UCR crime definitions, enter the actual number of incidents reported to your Tribe for the following crime types. Note that only those incidents for which your Tribe had primary response authority should be provided."]
[]
[null,null,"UCR Data *"]
[null,null,"Year"]
[null,null,"Criminal Homicide"]
[null,null,"Forcible Rape"]
[null,null,"Robbery"]
[null,null,"Aggravated Assault"]
[null,null,"Burglary"]
[null,null,"Larceny (except motor vehicle theft)"]
[null,null,"Motor Vehicle Theft"]
[]
[null,"*Note: If your Tribe is not using UCR data or reports to NIBRS, please explain the source or methods used to report your crime data. If you do not report crime incidents at all please explain why you are unable to provide such data. If instructions are needed on converting your data to UCR Summary Data style please view the COPS Application Guide of the FBI's UCR Handbook (www.fbi.gov/ucr/handbook/ucrhandbook04.pdf) for more information."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The FBI is retiring the current Summary Reporting System (SRS) and will transition to an all-NIBRS data collection system within the next five years. The transition to NIBRS will provide a more complete and accurate picture of crime at the tribal, national, state, and local level. As of 2021, the FBI will no longer collect summary data and will only accept data in the NIBRS format and COPS Office awards will be based on submitted NIBRS data. Transitioning all law enforcement agencies to NIBRS is the first step in gathering more comprehensive crime data. Tribal, state, and local COPS grantees are encouraged to expedite the transition to NIBRS in their jurisdictions so that they will remain eligible to receive COPS Office awards."]
[]
["III. Tribal Law Enforcement Information"]
[null,"Please answer the following questions. NOTE: If you choose \"none\" for question 1 you are finished completing this section and do not need to answer 1a or 1b."]
[null,"1. What law enforcement agency or departments does your Tribe operate? (check all that apply):"]
[]
[]
[]
[]
[]
[]
[]
[null,"a. What is the actual population your department serves as the primary law enforcement agency entity?"]
[null,null,"This may or may not be the same as the population reported in the U.S. Census, the Tribe's current enrollment or the local population base. A Tribe with primary law enforcement authority is defined as having first responder responsibility to calls for service for all types of criminal incidents within its jurisdiction."]
[]
[]
[null,"b. Enter the current Fiscal Year Actual Sworn Force Strength as of the date of this application:"]
[null,null,"The actual number of sworn officer positions is the actual number of sworn positions employed by your Tribe as of the date of this application. Do not include funded but currently vacant positions or unpaid positions. NOTE: For Tribes with multiple component law enforcement departments (e.g. Department of Public Safety and Fish and Wildlife Department), please report cumulative, full- and part-time sworn-force strength number for all law enforcement departments in your Tribe which would receive funding through this request if awarded."]
[null,null,"Full-Time:",null,null,"Part-Time:"]
[]
[null,"2. On average how many hours of IN-SERVICE (non-recruit) training (e.g. FTO, continuing professional education, roll call, standard) are required annually for each of your agency’s officers/deputies in the following categories (if none, please indicate 0 hours)?"]
[]
[null,null,"Use of Force:",null,null,"De-escalation of conflict:"]
[]
[null,null,"Racial and ethnic bias that includes elements of implicit/unconscious bias:     "]
[]
[]
[null,null,"Gender bias in response to domestic violence and sexual assault:"]
[]
[null,null,"Bias towards lesbian, gay, bisexual, and transgender (LGBT) individuals:"]
[]
[null,null,"Community engagement (e.g., community policing and problem solving):"]
[]
[null,"3. Does your agency administer a police training academy? "]
[]
[null,"4. How many total hours of basic/recruit ACADEMY training are required for each of your agency’s officer/deputy recruits in the following categories (if none, please indicate 0 hours)?"]
[]
[null,null,"Use of Force:",null,null,"De-escalation of conflict:"]
[]
[null,null,"Racial and ethnic bias that includes elements of implicit/unconscious bias:     "]
[]
[]
[null,null,"Gender bias in response to domestic violence and sexual assault:"]
[]
[null,null,"Bias towards lesbian, gay, bisexual, and transgender (LGBT) individuals:"]
[]
[null,null,"Community engagement (e.g., community policing and problem solving):"]
[]
["IV. Tribal Facilities, Capacities and Capabilities"]
[null,"1. Telecommunications and Technology"]
[null,"a. Describe your Internet Access:"]
[]
[]
[]
[]
[]
[null,"b. What types of communication services are generally available to the tribe at large and/or the tribe's justice components? (check all that apply)"]
[]
[null,null,null,null,null,null,null,"Tribe","Justice "]
[null,null,"i. Land Line (telephone, dial-up service)"]
[null,null,"ii. Cellular (telephone, data, etc.)"]
[null,null,"iii. Satellite - Receive only (broadcasting services)"]
[null,null,"iv. Satellite - 2-way (2-way voice and data and well as broadcasting)"]
[null,null,"v. Radio services  - (HF, VHF, UHF)"]
[null,null,"vi. Point to Point Microwave "]
[null,null,"vii. Other (please describe)"]
[null,null,null,"Tribal"]
[]
[null,null,null,"Justice Comp."]
[]
[null,"2. Facilities and Services (check all that apply)"]
[null,"Applicants should check and provide data for all the facilities and services located within the reservation/jurisdiction described in question 8 above. "]
[]
[null,null,null,null,null,null,"# of beds"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of beds"]
[null,null,null,null,null,null,"# of beds"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]
[null,null,null,null,null,null,"# of facilities"]

{"sheet":"Budget Detail - Year 1","index":2,"n_rows":176,"n_cols":12,"rows_kept":176,"cut":false,"hidden":false,"merged":[[49,6,50,6],[49,7,50,7],[87,0,87,2],[87,3,87,4],[87,5,87,8],[86,0,86,2],[86,3,86,4],[86,5,86,8],[117,3,117,5],[103,5,103,8],[106,0,107,11],[103,3,103,4],[103,1,103,2],[89,0,89,2],[51,1,51,2],[59,1,59,2],[58,1,58,2],[89,3,89,4],[85,0,85,2],[83,9,84,9],[1,10,2,11],[124,0,124,8],[123,3,123,5],[123,1,123,2],[121,1,121,2],[121,3,121,5],[122,1,122,2],[122,3,122,5],[119,6,120,6],[119,7,120,7],[119,8,120,8],[98,3,98,11],[110,0,110,1],[109,0,109,1],[113,0,113,1],[114,0,114,1],[109,9,110,11],[111,9,112,9],[104,0,104,8],[49,9,50,9],[113,2,113,6],[114,2,114,6],[89,5,89,8],[85,3,85,4],[148,1,148,2],[148,3,148,5],[149,0,149,8],[160,2,160,3],[160,5,160,6],[119,9,120,9],[91,0,91,8],[97,1,97,2],[99,0,100,2],[98,1,98,2],[99,5,100,8],[102,1,102,2],[102,3,102,4],[102,5,102,8],[101,3,101,4],[99,3,100,4],[101,1,101,2],[93,0,95,11],[97,3,97,11],[99,10,100,10],[99,11,100,11],[111,10,112,10],[99,9,100,9],[101,5,101,8],[160,0,160,1],[154,0,154,1],[156,5,157,6],[158,5,158,6],[156,2,157,3],[156,4,157,4],[156,7,157,8],[158,2,158,3],[159,0,159,1],[159,2,159,3],[158,7,158,8],[160,7,160,8],[154,2,154,11],[155,2,155,11],[155,0,155,1],[146,3,146,5],[175,0,176,11],[170,3,170,4],[172,3,172,4],[168,3,169,4],[168,9,169,9],[168,10,169,10],[168,11,169,11],[168,0,169,2],[170,0,170,2],[173,0,173,8],[168,5,169,8],[170,5,170,8],[172,5,172,8],[172,0,172,2],[171,0,171,2],[171,3,171,4],[171,5,171,8],[156,11,157,11],[156,10,157,10],[156,9,157,9],[159,5,159,6],[159,7,159,8],[158,0,158,1],[69,0,69,2],[68,0,68,2],[70,0,71,2],[83,11,84,11],[83,0,84,2],[57,1,57,2],[138,0,138,1],[116,0,116,1],[117,1,117,2],[118,1,118,2],[117,6,117,11],[111,11,112,11],[115,0,115,8],[119,10,120,10],[144,0,145,5],[144,6,145,6],[144,7,145,7],[144,8,145,8],[126,0,127,11],[129,7,129,8],[83,10,84,10],[83,3,84,4],[31,0,31,2],[31,3,31,4],[31,5,31,8],[34,0,34,2],[34,3,34,4],[34,5,34,8],[60,0,60,8],[70,5,71,8],[72,5,72,8],[69,3,69,11],[70,3,71,4],[70,9,71,9],[70,10,71,10],[62,0,66,11],[68,3,68,11],[70,11,71,11],[137,2,137,6],[130,0,130,1],[135,2,135,6],[135,7,135,8],[118,3,118,5],[119,11,120,11],[119,0,120,5],[142,6,142,11],[143,1,143,2],[143,3,143,5],[143,6,143,11],[142,1,142,2],[142,3,142,5],[147,1,147,2],[147,3,147,5],[141,0,141,1],[146,1,146,2],[129,0,129,1],[131,10,132,10],[49,10,50,10],[48,1,48,2],[28,0,28,2],[47,1,47,2],[28,5,28,8],[36,5,36,8],[36,0,36,2],[37,0,37,8],[49,8,50,8],[39,0,45,11],[47,5,47,11],[48,5,48,11],[49,11,50,11],[28,3,28,4],[36,3,36,4],[49,0,50,4],[49,5,50,5],[33,0,33,2],[0,0,0,5],[0,7,0,11],[6,11,7,11],[8,5,8,6],[16,5,16,6],[6,0,7,1],[6,4,7,4],[6,5,7,6],[6,9,7,9],[6,10,7,10],[5,2,5,11],[4,2,4,11],[6,2,7,3],[8,2,8,3],[16,2,16,3],[6,7,7,8],[8,7,8,8],[16,7,16,8],[15,2,15,3],[15,5,15,6],[15,7,15,8],[14,2,14,3],[14,5,14,6],[14,7,14,8],[1,0,1,9],[2,0,2,1],[75,3,75,4],[72,0,72,2],[82,0,82,2],[11,5,11,6],[11,7,11,8],[10,2,10,3],[10,5,10,6],[10,7,10,8],[13,2,13,3],[13,5,13,6],[13,7,13,8],[76,0,76,8],[78,0,79,11],[81,3,81,11],[82,3,82,11],[72,3,72,4],[74,0,74,2],[73,5,73,8],[55,1,55,2],[54,1,54,2],[9,2,9,3],[9,5,9,6],[167,0,167,2],[166,0,166,2],[163,0,164,11],[166,3,166,11],[167,3,167,11],[161,0,161,8],[151,0,152,11],[144,11,145,11],[109,2,109,6],[110,2,110,6],[109,7,109,8],[110,7,110,8],[113,7,113,8],[133,0,133,1],[139,0,139,1],[128,0,128,1],[138,2,138,6],[139,2,139,6],[137,7,137,8],[136,0,136,1],[136,2,136,6],[114,7,114,8],[144,9,145,9],[144,10,145,10],[30,3,30,4],[30,5,30,8],[12,2,12,3],[12,5,12,6],[12,7,12,8],[11,2,11,3],[19,0,22,11],[30,0,30,2],[17,0,17,8],[26,11,27,11],[24,3,24,11],[9,7,9,8],[26,0,27,2],[26,5,27,8],[26,9,27,9],[26,10,27,10],[26,3,27,4],[25,3,25,11],[25,0,25,2],[24,0,24,2],[81,0,81,2],[75,0,75,2],[131,11,132,11],[140,0,140,8],[138,7,138,8],[139,7,139,8],[131,9,132,9],[75,5,75,8],[83,5,84,8],[85,5,85,8],[90,0,90,2],[129,2,129,6],[130,2,130,6],[130,7,130,8],[131,0,132,1],[133,2,133,6],[133,7,133,8],[136,7,136,8],[135,0,135,1],[118,6,118,11],[134,0,134,1],[134,2,134,6],[134,7,134,8],[137,0,137,1],[74,3,74,4],[74,5,74,8],[29,0,29,2],[29,3,29,4],[29,5,29,8],[35,0,35,2],[35,3,35,4],[108,0,108,1],[33,3,33,4],[33,5,33,8],[32,0,32,2],[32,3,32,4],[32,5,32,8],[53,1,53,2],[52,1,52,2],[35,5,35,8],[56,1,56,2],[90,5,90,8],[73,0,73,2],[73,3,73,4],[88,0,88,2],[88,3,88,4],[88,5,88,8],[90,3,90,4]]}
[{"$f":"'Budget Sheet Instructions'!A17","v":"Budget Detail - Year 1"}]
["Does this budget contain conference costs which is defined broadly to include meetings, retreats, seminars, symposia, and training activities? - Y/N",null,null,null,null,null,null,null,null,null,"Yes"]
["(DOJ Financial Guide, Section 3.10)"]
["A. Personnel"]
["Name","Position","Computation"]
["List each name, if known.","List each position, if known.","Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"Salary ",null,"Rate","Time Worked\n(# of hours, days, months, years)",null,"Percentage of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C9*F9*H9,1)","v":0},null,{"$f":"IF(J9-K9<0,0,J9-K9)","v":0}]
["Donna Michaelis","Grant oversight",99840,null,"yearly",1,null,0.1,null,9984,9984,0]
["Project Coordinator (TBD)","Project Coordinator",72800,null,"yearly",1,null,1,null,72800,null,72800]
["David Cotter","Legal Support",124800,null,"yearly",1,null,0.05,null,6240,6240,0]
["Marc Dawkins","Training Support",72800,null,"yearly",1,null,0.1,null,7280,7280,0]
["Shellie Evers","Communication, Procurement, and Training Support",64480,null,"yearly",1,null,0.15,null,9672,9672,0]
["Jim McDonough","Research Support",99840,null,"yearly",1,null,0.15,null,14976,14976,0]
["Grant Support Specialist (TBD)","Grant Support Specialist",31,null,"hourly",1490,null,1,null,46190,null,46190]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J17)","v":167142},{"$f":"SUM(K9:K17)","v":48152},{"$f":"SUM(L9:L17)","v":118990}]
["Narrative"]
["Donna Michaelis, Manager, will provide oversight on the entire award providing 10% of her time on the project. A Project coordinator and Gant Support Specialist will manage the project, facilitate trainings, complete reports and submit deliverables spending 100% of their time on the project. Dave Cotter, Attorney, will provide legal consultation in the development of the case management tool. Marc Dawkins, training coordinator will provide training facilitation, spending 10% of his time on the project. Shellie Evers, training coordinator and school safety specialist will provide communication, procurement, and training support, spending 15% of her time on this project.  Jim McDonough, researcher, will provide critical and ongoing data, and will spend 15% of his time on the project.   All staff support, with the exception of the Project Coordinator and Grant Support Specialist, are being offered in kind. Additional duties will be added to each position as needed to support this grant project.  Calculations are based on additional responsibilities and a percentage of salaries annually."]
[]
[]
[]
["B. Fringe Benefits"]
["Name",null,null,"Computation"]
["List each grant-supported position receiving fringe benefits.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D29*F29,1)","v":0},null,{"$f":"IF(J29-K29<0,0,J29-K29)","v":0}]
["Grant Support Specialist (TBD)",null,null,46190,null,7.6499999999999999E-2,null,null,null,{"$f":"CEILING(D30*F30,1)","v":3534},null,{"$f":"IF(J30-K30<0,0,J30-K30)","v":3534}]
["Donna Michaelis",null,null,9984,null,0.45,null,null,null,4493,4493,0]
["Project Coordinator (TBD)",null,null,72800,null,0.35,null,null,null,25480,null,25480]
["David Cotter",null,null,6240,null,0.45,null,null,null,2808,2808,0]
["Marc Dawkins",null,null,7280,null,0.45,null,null,null,3276,3276,0]
["Shellie Evers",null,null,9672,null,0.45,null,null,null,4353,4353,0]
["Jim McDonough",null,null,14976,null,0.45,null,null,null,6740,6740,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J29:J37)","v":50684},{"$f":"SUM(K29:K37)","v":21670},{"$f":"SUM(L29:L37)","v":29014}]
["Narrative"]
["DCJS' state fringe benefits rate is 45% and includes taxes, annual leave, FICA, health insurance, retirement, and long term disability.  The benefits fo for the coordinator are 35% and 7.65% for the part-time employee to cover Social Security and Workers Comp. Benefits are about 30% of the base before health insurance.  Medical/Hospitalization Insurance: includes expenditures of group medical/ hospitalization insurance program provided for the benefit of State employees and can vary based on status: Employee-$8,244; Employee plus 1-$14,748; and Family-$21,624.  This can add 12% to 30% more cost to the benefits percentage. \n\nThe benefits base of 30% is comprised of:\n\nFederal Old-Age Insurance for Salaried State Employees: Includes expenditures of Contribution Fund for old-age and survivors’ benefits for salaried State employees (social security). \n\nFederal Old-Age Insurance for Wage-Earning State Employees: Includes expenditures of Contribution Fund for old-age and survivors’ benefits for wage-earning State employees.\n\nEmployer Retirement Contributions - VRS Defined Benefits Program: Includes expenditures for payments made to the retirement system trust fund for a defined benefit program for salaried State employees.\n\nGroup Life Insurance: Includes expenditures of group life insurance program provided for the benefit of State employees.\n\nRetiree Medical/Hospitalization Insurance Credit: Includes expenditures for payments to the Retiree Health Insurance Fund. \n\nLong-term Disability Insurance: Includes expenditures of the long-term disability program provided for the benefit of state employees.\n\nDeferred Compensation Match Payments: Includes expenditures for employer match of the state employee deferred compensation program.  The maximum amount paid is 50% of employee contribution with a ceiling of $40.00 per month.  \n"]
[]
[]
[]
[]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense","Basis","Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Lodging, Meals, Etc.","Per day, mile, trip, Etc.","Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Quantity","# of Staff","# of Trips","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,{"$f":"IF((D52=\"Lodging\"),\"Night\",IF((D52=\"Meals\"),\"Day\",IF((D52=\"Mileage\"),\"Mile\",IF((D52=\"Transportation\"),\"Round-trip\",\"N/A\"))))","v":"N/A"},null,null,null,null,{"$f":"CEILING(F52*G52*H52*I52,1)","v":0},null,{"$f":"IF(J52-K52<0,0,J52-K52)","v":0}]
["DCJS Vehicle (**see calculation below)","Statewide",null,"Mileage","Mile",0.57999999999999996,406,2,16,7536,7536,0]
["Mandatory Orientation Training","Washington, DC",null,"Meals","Day",69,2.5,3,1,518,null,518]
["Mandatory Orientation Training","Washington, DC",null,"Lodging","Night",225,2,3,1,1350,null,1350]
["K-12 Threat Assessment","Varies",null,"Meals","Day",51,1.5,1,12,918,null,918]
["K-12 Threat Assessment","Varies",null,"Lodging","Night",93,1,1,12,1116,null,1116]
["TTT Training","Varies",null,"Meals","Day",51,2.5,1,4,510,null,510]
["TTT Training","Varies",null,"Lodging","Night",93,2,1,4,744,null,744]
[null,null,null,null,"N/A",null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J52:J60)","v":12692},{"$f":"SUM(K52:K60)","v":7536},{"$f":"SUM(L52:L60)","v":5156}]
["Narrative"]
["DCJS will provide a state vehicle for travel to the training coordinator and program coordinator.  The coordinators will need access to a vehicle to meet with school division personnel and to attend and deliver training.  The vehicles will be tracked for in-kind matching purposes.  Mileage is based on the  coordinators attending and delivering the sixteen (16) trainings per year with an average roundtrip of 406 per training (406 miles x .58 per mile = $235 x 16 trainings = $3768). Per award guidelines, key members must attend orientation training in Washington, DC. We are following our own travel policy. Per-diem rates in DC are $69 for meals, and lodging varies from $175 to $225 based on the time of year.  Lodging is for 2 nights and meals are budgeted at 2.5 days as the two travel days are computed at .75 days. K-12 Lodging is for one night for 12 trainings at $93 standard rate and meals are budgeted standard rate of $51 at 1.5 days as the two travel days are computed at .75 days TTT training is for 2 nights for 4 sessions at $93 standard rate and meals are budgeted at the standard rate of $51 for 2.5 days as the two travel days are computed at .75 days."]
[]
[]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Unit Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D73*F73,1)","v":0},null,{"$f":"IF(J73-K73<0,0,J73-K73)","v":0}]
["Dell laptop computer",null,null,2,null,850,null,null,null,1700,1700,0]
["Dell printer",null,null,2,null,200,null,null,null,400,400,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J73:J76)","v":2100},{"$f":"SUM(K73:K76)","v":2100},{"$f":"SUM(L73:L76)","v":0}]
["Narrative"]
["The project coordinator and Grant Support Specialist will need a laptop computer  a printer for their office. We are following our agency's capitalization policy.  This equipment will be purchased upon hire and offered in kind."]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Unit Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D86*F86,1)","v":0},null,{"$f":"IF(J86-K86<0,0,J86-K86)","v":0}]
["Cellphone",null,null,1,null,660,null,null,null,660,660,0]
["Aircard ",null,null,1,null,100,null,null,null,100,100,0]
["Training Materials for K-12 Training ",null,null,480,null,7,null,null,null,3360,null,3360]
["Training materials for TTT",null,null,40,null,25,null,null,null,1000,null,1000]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J86:J91)","v":5120},{"$f":"SUM(K86:K91)","v":760},{"$f":"SUM(L86:L91)","v":4360}]
["Narrative"]
["The project coordinator will need a cellphone and aircard while out in the field.  The aircard is used for remote access to the agency's internet service when in the field and connecting to wi-fi while on site for training and train the trainer meetings. Training material includes handouts, pens, and basic office supplies. The training supplies for K-12 Threat Assessment are based on a 12 training session with 40 participants per session. The training supplies for the TTT training are based on 4 trainings with 10 participants per session. These amounts were determined based upon other trainings that we have completed in the past. "]
[]
[]
["F. Construction"]
["Purpose","Description of Work",null,"Computation"]
["Provide the purpose of the construction","Describe the construction project(s)",null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D102*F102,1)","v":0},null,{"$f":"IF(J102-K102<0,0,J102-K102)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D103*F103,1)","v":0},null,{"$f":"IF(J103-K103<0,0,J103-K103)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D104*F104,1)","v":0},null,{"$f":"IF(J104-K104<0,0,J104-K104)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J102:J104)","v":0},{"$f":"SUM(K102:K104)","v":0},{"$f":"SUM(L102:L104)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Description",null,"Purpose",null,null,null,null,"Consultant?"]
["Provide a description of the activities to be carried out by subrecipients.",null,"Describe the purpose of the subaward (subgrant)",null,null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost."]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J114-K114<0,0,J114-K114)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J115-K115<0,0,J115-K115)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J114:J115)+J125","v":0},{"$f":"SUM(K114:K115)+K125","v":0},{"$f":"SUM(L114:L115)+L125","v":0}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G122*H122*I122,1)","v":0},null,{"$f":"IF(J122-K122<0,0,J122-K122)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G123*H123*I123,1)","v":0},null,{"$f":"IF(J123-K123<0,0,J123-K123)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G124*H124*I124,1)","v":0},null,{"$f":"IF(J124-K124<0,0,J124-K124)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J122:J124)","v":0},{"$f":"SUM(K122:K124)","v":0},{"$f":"SUM(L122:L124)","v":0}]
["Narrative"]
[" "]
[]
["H. Procurement Contracts"]
["Description",null,"Purpose",null,null,null,null,"Consultant?"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000). ",null,"Describe the purpose of the contract",null,null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost."]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J134-K134<0,0,J134-K134)","v":0}]
["Consultant TBD",null,"Provide access to technical assistance as school divisions implement threat assessment processes",null,null,null,null,"Yes",null,4800,null,4800]
["K-12 Threat Assessment Training ",null,"Provide training in behavioral threat assessment to threat assessment teams across the Commonwealth. ",null,null,null,null,"No",null,48000,12000,36000]
["Train the Trainer - K-12 Threat Assessment",null,"train school personnel  to teach threat assessment training",null,null,null,null,"No",null,32000,null,32000]
["On-line threat assessment training for teachers",null,"Develop and produce an on-line training in threat assessment for teachers and make it  available to divisions across the Commonwealth.",null,null,null,null,"No",null,50000,null,50000]
["Case Management Tool",null,"Develop an on-line case management tool that will facilitate process development, data collection and case management",null,null,null,null,"No",null,30000,null,30000]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J134:J140)+J150","v":164800},{"$f":"SUM(K134:K140)+K150","v":12000},{"$f":"SUM(L134:L140)+L150","v":152800}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G147*H147*I147,1)","v":0},null,{"$f":"IF(J147-K147<0,0,J147-K147)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G148*H148*I148,1)","v":0},null,{"$f":"IF(J148-K148<0,0,J148-K148)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G149*H149*I149,1)","v":0},null,{"$f":"IF(J149-K149<0,0,J149-K149)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J147:J149)","v":0},{"$f":"SUM(K147:K149)","v":0},{"$f":"SUM(L147:L149)","v":0}]
["Narrative"]
["DCJS will utilize an RFP process to identify a vendor to provide 60 hours of consultation services to school divisions.  The rate is expected to be $80 per hour based on a previous project.  DCJS will use the RFP process to identify a vendor to adapt the DCJS training curriculum to include activities to directly support school divisions to identify and strengthen their existing threat assessment processes.  The vendor will then provide the trainings to targeted school divisions. DCJS will utilize the RFP process to hire a vendor to present the DCJS Train the Trainer curriculum. The project coordinator will work with the vendor to adapt the current curriculum to match the updated K-12 threat assessment curriculum.  DCJS will use the RFP process to identify a vendor to create the case management tool. "]
[]
["I. Other Costs"]
["Description ",null,"Computation"]
["List and describe items that will be paid with grants funds (e.g. rent, reproduction, telephone, janitorial, or security services, and investigative or confidential funds).",null,"Show the basis for computation"]
[null,null,"Quantity",null,"Basis","Cost",null,"Length of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C159*F159*H159,1)","v":0},null,{"$f":"IF(J159-K159<0,0,J159-K159)","v":0}]
["Safety Audit Report",null,1,null,null,5400,null,1,null,{"$f":"CEILING(C160*F160*H160,1)","v":5400},5400,{"$f":"IF(J160-K160<0,0,J160-K160)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C161*F161*H161,1)","v":0},null,{"$f":"IF(J161-K161<0,0,J161-K161)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J159:J161)","v":5400},{"$f":"SUM(K159:K161)","v":5400},{"$f":"SUM(L159:L161)","v":0}]
["Narrative"]
["In the Commonwealth of Virginia, all public schools are required to conduct an annual school safety audit in order to assess school safety conditions. Through enabling legislation (legislation (§ 9.1-184), the Virginia Center for School and Campus Safety (VCSCS) has been designated to collect, analyze, and disseminate various Virginia school safety data including school safety audit information. In 2005, the General Assembly transferred the authority to collect school safety audit information from the Department of Education to the Department of Criminal Justice Services. To date, the VCSCS has developed five components for the school safety audit program: Virginia School Safety Survey, the Division Level Survey,  Virginia School Crisis Management Plan Review and Certification, Virginia Secondary School Climate Survey, and the School Safety Inspection Checklist (due every three years; next due date August 2020).  This cost is associated with the printing and dissemination of this document to support the work of threat assessment teams."]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D171*F171,1)","v":0},null,{"$f":"IF(J171-K171<0,0,J171-K171)","v":0}]
["Indirect cost agains salaries and wages",null,null,218004,null,3.984E-2,null,null,null,{"$f":"CEILING(D172*F172,1)","v":8686},null,{"$f":"IF(J172-K172<0,0,J172-K172)","v":8686}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D173*F173,1)","v":0},null,{"$f":"IF(J173-K173<0,0,J173-K173)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J171:J173)","v":8686},{"$f":"SUM(K171:K173)","v":0},{"$f":"SUM(L171:L173)","v":8686}]
["Narrative"]
["DCJS has a federally negotiated Indirect Cost Rate Agreemnet (Attached) of 17.55% for FY2019 and 15.62% for FY2020.  For the purposes of this grant we are only applying 3.98% against the negotiated salries and wages base.  A copy of the Department of Justice negotiated agreement letter is attached.  Should we realize a cost savings or need to charge more of the rate we will submit a budget modification request in accoradnce with 2 CFR § 200.414. "]

{"sheet":"Budget Detail - Year 2","index":3,"n_rows":166,"n_cols":12,"rows_kept":166,"cut":false,"hidden":false,"merged":[[162,0,162,2],[162,3,162,4],[162,5,162,8],[163,0,163,8],[165,0,166,11],[160,0,160,2],[160,3,160,4],[160,5,160,8],[156,0,156,2],[156,3,156,11],[157,0,157,2],[157,3,157,11],[158,0,159,2],[158,3,159,4],[158,5,159,8],[158,9,159,9],[158,10,159,10],[158,11,159,11],[161,0,161,2],[161,3,161,4],[161,5,161,8],[150,0,150,1],[150,2,150,3],[150,5,150,6],[150,7,150,8],[151,0,151,8],[153,0,154,11],[146,11,147,11],[148,0,148,1],[148,2,148,3],[148,5,148,6],[148,7,148,8],[149,0,149,1],[149,2,149,3],[149,5,149,6],[149,7,149,8],[146,2,147,3],[146,4,147,4],[146,5,147,6],[146,7,147,8],[146,9,147,9],[146,10,147,10],[139,0,139,8],[141,0,142,11],[144,0,144,1],[144,2,144,11],[145,0,145,1],[145,2,145,11],[136,1,136,2],[136,3,136,5],[137,1,137,2],[137,3,137,5],[138,1,138,2],[138,3,138,5],[133,1,133,2],[133,3,133,5],[133,6,133,11],[134,0,135,5],[134,6,135,6],[134,7,135,7],[134,8,135,8],[134,9,135,9],[134,10,135,10],[134,11,135,11],[129,0,129,1],[129,2,129,6],[129,7,129,8],[130,0,130,8],[131,0,131,1],[132,1,132,2],[132,3,132,5],[132,6,132,11],[121,11,122,11],[123,0,123,1],[123,2,123,6],[123,7,123,8],[128,0,128,1],[128,2,128,6],[128,7,128,8],[127,0,127,1],[127,2,127,6],[127,7,127,8],[126,0,126,1],[126,2,126,6],[126,7,126,8],[125,0,125,1],[125,2,125,6],[125,7,125,8],[120,0,120,1],[120,2,120,6],[120,7,120,8],[121,0,122,1],[121,9,122,9],[121,10,122,10],[114,0,114,8],[116,0,117,11],[118,0,118,1],[119,0,119,1],[119,2,119,6],[119,7,119,8],[109,11,110,11],[111,1,111,2],[111,3,111,5],[112,1,112,2],[112,3,112,5],[113,1,113,2],[113,3,113,5],[109,0,110,5],[109,6,110,6],[109,7,110,7],[109,8,110,8],[109,9,110,9],[109,10,110,10],[105,0,105,8],[106,0,106,1],[107,1,107,2],[107,3,107,5],[107,6,107,11],[108,1,108,2],[108,3,108,5],[108,6,108,11],[104,0,104,1],[104,2,104,6],[104,7,104,8],[101,9,102,9],[101,10,102,10],[101,11,102,11],[103,0,103,1],[103,2,103,6],[103,7,103,8],[99,0,99,1],[99,2,99,6],[99,7,99,8],[99,9,100,11],[100,0,100,1],[100,2,100,6],[100,7,100,8],[93,1,93,2],[93,3,93,4],[93,5,93,8],[94,0,94,8],[96,0,97,11],[98,0,98,1],[91,1,91,2],[91,3,91,4],[91,5,91,8],[92,1,92,2],[92,3,92,4],[92,5,92,8],[88,1,88,2],[88,3,88,11],[89,0,90,2],[89,3,90,4],[89,5,90,8],[89,9,90,9],[89,10,90,10],[89,11,90,11],[81,0,81,2],[81,3,81,4],[81,5,81,8],[82,0,82,8],[84,0,85,11],[87,1,87,2],[87,3,87,11],[77,0,77,2],[77,3,77,4],[77,5,77,8],[80,0,80,2],[80,3,80,4],[80,5,80,8],[74,0,74,2],[74,3,74,11],[75,0,76,2],[75,3,76,4],[75,5,76,8],[75,9,76,9],[75,10,76,10],[75,11,76,11],[79,0,79,2],[79,3,79,4],[79,5,79,8],[78,0,78,2],[78,3,78,4],[78,5,78,8],[67,0,67,2],[67,3,67,4],[67,5,67,8],[68,0,68,8],[70,0,71,11],[73,0,73,2],[73,3,73,11],[65,0,65,2],[65,3,65,4],[65,5,65,8],[66,0,66,2],[66,3,66,4],[66,5,66,8],[45,9,46,9],[45,10,46,10],[45,11,46,11],[62,0,62,2],[62,3,62,11],[63,0,64,2],[63,3,64,4],[63,5,64,8],[63,9,64,9],[63,10,64,10],[63,11,64,11],[47,1,47,2],[52,1,52,2],[53,1,53,2],[54,0,54,8],[56,0,59,11],[61,0,61,2],[61,3,61,11],[48,1,48,2],[51,1,51,2],[50,1,50,2],[49,1,49,2],[28,0,28,2],[28,3,28,4],[28,5,28,8],[35,0,35,2],[35,3,35,4],[35,5,35,8],[34,0,34,2],[34,3,34,4],[34,5,34,8],[33,0,33,2],[33,3,33,4],[33,5,33,8],[32,0,32,2],[32,3,32,4],[30,0,30,2],[30,3,30,4],[30,5,30,8],[29,0,29,2],[29,3,29,4],[29,5,29,8],[26,3,27,4],[26,5,27,8],[26,9,27,9],[26,10,27,10],[26,11,27,11],[16,2,16,3],[16,5,16,6],[16,7,16,8],[17,0,17,8],[19,0,22,11],[24,0,24,2],[24,3,24,11],[25,0,25,2],[25,3,25,11],[26,0,27,2],[11,2,11,3],[11,5,11,6],[11,7,11,8],[10,2,10,3],[10,5,10,6],[10,7,10,8],[0,0,0,5],[0,7,0,11],[1,0,1,9],[1,10,2,11],[2,0,2,1],[4,2,4,11],[8,2,8,3],[8,5,8,6],[8,7,8,8],[5,2,5,11],[6,0,7,1],[6,2,7,3],[6,4,7,4],[6,5,7,6],[6,7,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[12,2,12,3],[12,5,12,6],[12,7,12,8],[15,2,15,3],[15,5,15,6],[15,7,15,8],[14,2,14,3],[14,5,14,6],[14,7,14,8],[13,2,13,3],[13,5,13,6],[13,7,13,8],[9,2,9,3],[9,5,9,6],[9,7,9,8],[124,0,124,1],[124,2,124,6],[124,7,124,8],[32,5,32,8],[31,0,31,2],[31,3,31,4],[31,5,31,8],[36,0,36,2],[36,3,36,4],[36,5,36,8],[37,0,37,8],[39,0,41,11],[43,1,43,2],[43,5,43,11],[44,1,44,2],[44,5,44,11],[45,0,46,4],[45,5,46,5],[45,6,46,6],[45,7,46,7],[45,8,46,8]]}
[{"$f":"'Budget Sheet Instructions'!A18","v":"Budget Detail - Year 2"}]
["Does this budget contain conference costs which is defined broadly to include meetings, retreats, seminars, symposia, and training activities? - Y/N",null,null,null,null,null,null,null,null,null,"Yes"]
["(DOJ Financial Guide, Section 3.10)"]
["A. Personnel"]
["Name","Position","Computation"]
["List each name, if known.","List each position, if known.","Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"Salary ",null,"Rate","Time Worked\n(# of hours, days, months, years)",null,"Percentage of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C9*F9*H9,1)","v":0},null,{"$f":"IF(J9-K9<0,0,J9-K9)","v":0}]
["Donna Michaelis","Grant oversight",99840,null,"yearly",1,null,0.1,null,{"$f":"CEILING(C10*F10*H10,1)","v":9984},9984,{"$f":"IF(J10-K10<0,0,J10-K10)","v":0}]
["Project Coordinator (TBD)","Project Coordinator",72800,null,"yearly",1,null,1,null,72800,null,72800]
["David Cotter","Legal Support",124800,null,"yearly",1,null,0.05,null,6240,6240,0]
["Marc Dawkins","Training Support",72800,null,"yearly",1,null,0.1,null,7280,7280,0]
["Shellie Evers","Communication, Procurement, and Training Support",64480,null,"yearly",1,null,0.15,null,9672,9672,0]
["Jim McDonough","Research Support",99840,null,"yearly",1,null,0.15,null,14976,14976,0]
["Grant Support Specialist (TBD)","Grant Support Specialist",31,null,"hourly",1490,null,1,null,46190,null,46190]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J17)","v":167142},{"$f":"SUM(K9:K17)","v":48152},{"$f":"SUM(L9:L17)","v":118990}]
["Narrative"]
["Donna Michaelis, Manager, will provide oversight on the entire award providing 10% of her time on the project. A Project coordinator and Gant Support Specialist will manage the project, facilitate trainings, complete reports and submit deliverables spending 100% of their time on the project. Dave Cotter, Attorney, will provide legal consultation in the development of the case management tool. Marc Dawkins, training coordinator will provide training facilitation, spending 10% of his time on the project. Shellie Evers, training coordinator and school safety specialist will provide communication, procurement, and training support, spending 15% of her time on this project.  Jim McDonough, researcher, will provide critical and ongoing data, and will spend 15% of his time on the project.   All staff support, with the exception of the Project Coordinator and Grant Support Specialist, are being offered in kind. Additional duties will be added to each position as needed to support this grant project.  Calculations are based on additional responsibilities and a percentage of salaries annually."]
[]
[]
[]
["B. Fringe Benefits"]
["Name",null,null,"Computation"]
["List each grant-supported position receiving fringe benefits.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D29*F29,1)","v":0},null,{"$f":"IF(J29-K29<0,0,J29-K29)","v":0}]
["Grant Support Specialist (TBD)",null,null,46190,null,7.6499999999999999E-2,null,null,null,{"$f":"CEILING(D30*F30,1)","v":3534},null,{"$f":"IF(J30-K30<0,0,J30-K30)","v":3534}]
["Donna Michaelis",null,null,9984,null,0.45,null,null,null,4493,4493,0]
["Project Coordinator (TBD)",null,null,72800,null,0.35,null,null,null,25480,null,25480]
["David Cotter",null,null,6240,null,0.45,null,null,null,2808,2808,0]
["Marc Dawkins",null,null,7280,null,0.45,null,null,null,3276,3276,0]
["Shellie Evers",null,null,9672,null,0.45,null,null,null,4353,4353,0]
["Jim McDonough",null,null,14976,null,0.45,null,null,null,6740,6740,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J29:J37)","v":50684},{"$f":"SUM(K29:K37)","v":21670},{"$f":"SUM(L29:L37)","v":29014}]
["Narrative"]
["DCJS' state fringe benefits rate is 45% and includes taxes, annual leave, FICA, health insurance, retirement, and long term disability.  The benefits fo for the coordinator are 35% and 7.65% for the part-time employee to cover Social Security and Workers Comp. Benefits are about 30% of the base before health insurance.  Medical/Hospitalization Insurance: includes expenditures of group medical/ hospitalization insurance program provided for the benefit of State employees and can vary based on status: Employee-$8,244; Employee plus 1-$14,748; and Family-$21,624.  This can add 12% to 30% more cost to the benefits percentage. \n\nThe benefits base of 30% is comprised of:\n\nFederal Old-Age Insurance for Salaried State Employees: Includes expenditures of Contribution Fund for old-age and survivors’ benefits for salaried State employees (social security). \n\nFederal Old-Age Insurance for Wage-Earning State Employees: Includes expenditures of Contribution Fund for old-age and survivors’ benefits for wage-earning State employees.\n\nEmployer Retirement Contributions - VRS Defined Benefits Program: Includes expenditures for payments made to the retirement system trust fund for a defined benefit program for salaried State employees.\n\nGroup Life Insurance: Includes expenditures of group life insurance program provided for the benefit of State employees.\n\nRetiree Medical/Hospitalization Insurance Credit: Includes expenditures for payments to the Retiree Health Insurance Fund. \n\nLong-term Disability Insurance: Includes expenditures of the long-term disability program provided for the benefit of state employees.\n\nDeferred Compensation Match Payments: Includes expenditures for employer match of the state employee deferred compensation program.  The maximum amount paid is 50% of employee contribution with a ceiling of $40.00 per month.  "]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense","Basis","Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Lodging, Meals, Etc.","Per day, mile, trip, Etc.","Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Quantity","# of Staff","# of Trips","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,{"$f":"IF((D48=\"Lodging\"),\"Night\",IF((D48=\"Meals\"),\"Day\",IF((D48=\"Mileage\"),\"Mile\",IF((D48=\"Transportation\"),\"Round-trip\",\"N/A\"))))","v":"N/A"},null,null,null,null,{"$f":"CEILING(F48*G48*H48*I48,1)","v":0},null,{"$f":"IF(J48-K48<0,0,J48-K48)","v":0}]
["DCJS Vehicle (**see calculation below)","Statewide",null,"mileage","Mile",0.57999999999999996,406,2,16,{"$f":"CEILING(F49*G49*H49*I49,1)","v":7536},3768,{"$f":"IF(J49-K49<0,0,J49-K49)","v":3768}]
["K-12 Threat Assessment","Varies",null,"meals","Day",51,2.5,1,16,2040,null,2040]
["K-12 Threat Assessment","Varies",null,"Lodging","Night",93,1,1,16,1488,null,1488]
["TTT Training","Varies",null,"Meals","Day",51,2.5,1,4,510,null,510]
["TTT Training","Varies",null,"Lodging","Night",93,2,1,4,744,null,744]
[null,null,null,null,"N/A",null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J48:J54)","v":12318},{"$f":"SUM(K48:K54)","v":3768},{"$f":"SUM(L48:L54)","v":8550}]
["Narrative"]
["DCJS will provide a state vehicle for travel to the training coordinator and program coordinator.  The coordinators will need access to a vehicle to meet with school division personnel and to attend and deliver training.  The vehicles will be tracked for in-kind matching purposes.  Mileage is based on the  coordinators attending and delivering the sixteen (16) trainings per year with an average roundtrip of 406 per training (406 miles x .58 per mile = $235 x 16 trainings = $3768). Per award guidelines, key members must attend orientation training in Washington, DC. We are following our own travel policy. Per-diem rates in DC are $69 for meals, and lodging varies from $175 to $225 based on the time of year.  Lodging is for 2 nights and meals are budgeted at 2.5 days as the two travel days are computed at .75 days. K-12 Lodging is for one night for 12 trainings at $93 standard rate and meals are budgeted standard rate of $51 at 1.5 days as the two travel days are computed at .75 days TTT training is for 2 nights for 4 sessions at $93 standard rate and meals are budgeted at the standard rate of $51 for 2.5 days as the two travel days are computed at .75 days."]
[]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Unit Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D66*F66,1)","v":0},null,{"$f":"IF(J66-K66<0,0,J66-K66)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D67*F67,1)","v":0},null,{"$f":"IF(J67-K67<0,0,J67-K67)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D68*F68,1)","v":0},null,{"$f":"IF(J68-K68<0,0,J68-K68)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J66:J68)","v":0},{"$f":"SUM(K66:K68)","v":0},{"$f":"SUM(L66:L68)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Unit Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D78*F78,1)","v":0},null,{"$f":"IF(J78-K78<0,0,J78-K78)","v":0}]
["General Office supplies",null,null,12,null,150,null,null,null,{"$f":"CEILING(D79*F79,1)","v":1800},null,{"$f":"IF(J79-K79<0,0,J79-K79)","v":1800}]
["Training Material for K-12 Training",null,null,640,null,7,null,null,null,{"$f":"CEILING(D80*F80,1)","v":4480},null,{"$f":"IF(J80-K80<0,0,J80-K80)","v":4480}]
["Training Materials for TTT Training",null,null,40,null,25,null,null,null,{"$f":"CEILING(D81*F81,1)","v":1000},null,{"$f":"IF(J81-K81<0,0,J81-K81)","v":1000}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D82*F82,1)","v":0},null,{"$f":"IF(J82-K82<0,0,J82-K82)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J78:J82)","v":7280},{"$f":"SUM(K78:K82)","v":0},{"$f":"SUM(L78:L82)","v":7280}]
["Narrative"]
["General office supplies will be use by all personnel on this project and include: pens, pencils, paper, printer cartridges and general office supplies. The office supplies ar based on 12 months at $150 per month. This amount was determined based upon other projects of this size that we have completed. \n Training material includes handouts, pens, and basic office supplies. The training supplies for K-12 Threat Assessment are based on a 16 training sessions with 40 participants per session. The training supplies for the TTT training are based on 4 trainings with 10 participants per session. These amounts were determined based upon other trainings that we have completed in the past. "]
[]
["F. Construction"]
["Purpose","Description of Work",null,"Computation"]
["Provide the purpose of the construction","Describe the construction project(s)",null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D92*F92,1)","v":0},null,{"$f":"IF(J92-K92<0,0,J92-K92)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D93*F93,1)","v":0},null,{"$f":"IF(J93-K93<0,0,J93-K93)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D94*F94,1)","v":0},null,{"$f":"IF(J94-K94<0,0,J94-K94)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J92:J94)","v":0},{"$f":"SUM(K92:K94)","v":0},{"$f":"SUM(L92:L94)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Description",null,"Purpose",null,null,null,null,"Consultant?"]
["Provide a description of the activities to be carried out by subrecipients.",null,"Describe the purpose of the subaward (subgrant)",null,null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost."]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J104-K104<0,0,J104-K104)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J105-K105<0,0,J105-K105)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J104:J105)+J115","v":0},{"$f":"SUM(K104:K105)+K115","v":0},{"$f":"SUM(L104:L105)+L115","v":0}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G112*H112*I112,1)","v":0},null,{"$f":"IF(J112-K112<0,0,J112-K112)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G113*H113*I113,1)","v":0},null,{"$f":"IF(J113-K113<0,0,J113-K113)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G114*H114*I114,1)","v":0},null,{"$f":"IF(J114-K114<0,0,J114-K114)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J112:J114)","v":0},{"$f":"SUM(K112:K114)","v":0},{"$f":"SUM(L112:L114)","v":0}]
["Narrative"]
[" "]
[]
["H. Procurement Contracts"]
["Description",null,"Purpose",null,null,null,null,"Consultant?"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000). ",null,"Describe the purpose of the contract",null,null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost."]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J124-K124<0,0,J124-K124)","v":0}]
["Consultant TBD",null,"Provide access to technical assistance as school divisions implement threat assessment processes",null,null,null,null,"Yes",null,4800,null,4800]
["K-12 Threat Assessment Training ",null,"Provide training in behavioral threat assessment to threat assessment teams across the Commonwealth. ",null,null,null,null,"No",null,64002,16000,48002]
["Train the Trainer - K-12 Threat Assessment",null,"train school personnel  to teach threat assessment training",null,null,null,null,"No",null,32000,null,32000]
["Case Management Tool",null,"Develop an on-line case management tool that will facilitate process development, data collection and case management",null,null,null,null,"No",null,20000,null,20000]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J124:J130)+J140","v":120802},{"$f":"SUM(K124:K130)+K140","v":16000},{"$f":"SUM(L124:L130)+L140","v":104802}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G137*H137*I137,1)","v":0},null,{"$f":"IF(J137-K137<0,0,J137-K137)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G138*H138*I138,1)","v":0},null,{"$f":"IF(J138-K138<0,0,J138-K138)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G139*H139*I139,1)","v":0},null,{"$f":"IF(J139-K139<0,0,J139-K139)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J137:J139)","v":0},{"$f":"SUM(K137:K139)","v":0},{"$f":"SUM(L137:L139)","v":0}]
["Narrative"]
["DCJS will utilize an RFP process to identify a vendor to provide 60 hours of consultation services to school divisions.  The rate is expected to be $80 per hour based on a previous project.  DCJS will use the RFP process to identify a vendor to adapt the DCJS training curriculum to include activities to directly support school divisions to identify and strengthen their existing threat assessment processes.  The vendor will then provide the trainings to targeted school divisions. DCJS will utilize the RFP process to hire a vendor to present the DCJS Train the Trainer curriculum. The project coordinator will work with the vendor to adapt the current curriculum to match the updated K-12 threat assessment curriculum.  DCJS will use the RFP process to identify a vendor to create the case management tool. "]
[]
["I. Other Costs"]
["Description ",null,"Computation"]
["List and describe items that will be paid with grants funds (e.g. rent, reproduction, telephone, janitorial, or security services, and investigative or confidential funds).",null,"Show the basis for computation"]
[null,null,"Quantity",null,"Basis","Cost",null,"Length of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C149*F149*H149,1)","v":0},null,{"$f":"IF(J149-K149<0,0,J149-K149)","v":0}]
["School Safety Survey ",null,1,null,null,5400,null,1,null,{"$f":"CEILING(C150*F150*H150,1)","v":5400},5400,{"$f":"IF(J150-K150<0,0,J150-K150)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C151*F151*H151,1)","v":0},null,{"$f":"IF(J151-K151<0,0,J151-K151)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J149:J151)","v":5400},{"$f":"SUM(K149:K151)","v":5400},{"$f":"SUM(L149:L151)","v":0}]
["Narrative"]
["In the Commonwealth of Virginia, all public schools are required to conduct an annual school safety audit in order to assess school safety conditions. Through enabling legislation (legislation (§ 9.1-184), the Virginia Center for School and Campus Safety (VCSCS) has been designated to collect, analyze, and disseminate various Virginia school safety data including school safety audit information. In 2005, the General Assembly transferred the authority to collect school safety audit information from the Department of Education to the Department of Criminal Justice Services. To date, the VCSCS has developed five components for the school safety audit program: Virginia School Safety Survey, the Division Level Survey,  Virginia School Crisis Management Plan Review and Certification, Virginia Secondary School Climate Survey, and the School Safety Inspection Checklist (due every three years; next due date August 2020).  This cost is associated with the printing and dissemination of this document to support the work of threat assessment teams."]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D161*F161,1)","v":0},null,{"$f":"IF(J161-K161<0,0,J161-K161)","v":0}]
["Indirect cost agains salaries and wages",null,null,218004,null,3.984E-2,null,null,null,{"$f":"CEILING(D162*F162,1)","v":8686},null,{"$f":"IF(J162-K162<0,0,J162-K162)","v":8686}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D163*F163,1)","v":0},null,{"$f":"IF(J163-K163<0,0,J163-K163)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J161:J163)","v":8686},{"$f":"SUM(K161:K163)","v":0},{"$f":"SUM(L161:L163)","v":8686}]
["Narrative"]
["DCJS has a federally negotiated Indirect Cost Rate Agreemnet (Attached) of 17.55% for FY2019 and 15.62% for FY2020.  For the purposes of this grant we are only applying 3.98% against the negotiated salries and wages base.  A copy of the Department of Justice negotiated agreement letter is attached.  Should we realize a cost savings or need to charge more of the rate we will submit a budget modification request in accoradnce with 2 CFR § 200.414. "]

{"sheet":"Budget Detail - Year 3","index":4,"n_rows":163,"n_cols":12,"rows_kept":163,"cut":false,"hidden":false,"merged":[[158,0,158,2],[158,3,158,4],[158,5,158,8],[12,2,12,3],[12,5,12,6],[12,7,12,8],[0,0,0,5],[0,7,0,11],[1,0,1,9],[1,10,2,11],[2,0,2,1],[4,2,4,11],[8,2,8,3],[8,5,8,6],[8,7,8,8],[5,2,5,11],[6,0,7,1],[6,2,7,3],[6,4,7,4],[6,5,7,6],[6,7,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[10,2,10,3],[10,5,10,6],[10,7,10,8],[15,2,15,3],[15,5,15,6],[15,7,15,8],[14,2,14,3],[14,5,14,6],[14,7,14,8],[13,2,13,3],[13,5,13,6],[13,7,13,8],[25,11,26,11],[16,2,16,3],[16,5,16,6],[16,7,16,8],[17,0,17,8],[19,0,21,11],[23,0,23,2],[23,3,23,11],[25,0,26,2],[25,3,26,4],[25,5,26,8],[25,9,26,9],[25,10,26,10],[24,0,24,2],[24,3,24,11],[35,0,35,2],[35,3,35,4],[35,5,35,8],[36,0,36,8],[38,0,40,11],[42,1,42,2],[42,5,42,11],[27,0,27,2],[27,3,27,4],[27,5,27,8],[34,0,34,2],[34,3,34,4],[34,5,34,8],[29,0,29,2],[30,0,30,2],[31,0,31,2],[32,0,32,2],[29,5,29,8],[28,0,28,2],[28,3,28,4],[28,5,28,8],[43,1,43,2],[43,5,43,11],[44,0,45,4],[44,5,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[44,9,45,9],[44,10,45,10],[44,11,45,11],[60,0,60,2],[60,3,60,11],[61,0,62,2],[61,3,62,4],[61,5,62,8],[61,9,62,9],[61,10,62,10],[61,11,62,11],[46,1,46,2],[51,1,51,2],[52,1,52,2],[53,0,53,8],[55,0,57,11],[59,0,59,2],[59,3,59,11],[50,1,50,2],[49,1,49,2],[48,1,48,2],[47,1,47,2],[65,0,65,2],[65,3,65,4],[65,5,65,8],[66,0,66,8],[68,0,69,11],[71,0,71,2],[71,3,71,11],[63,0,63,2],[63,3,63,4],[63,5,63,8],[64,0,64,2],[64,3,64,4],[64,5,64,8],[75,0,75,2],[75,3,75,4],[75,5,75,8],[78,0,78,2],[78,3,78,4],[78,5,78,8],[72,0,72,2],[72,3,72,11],[73,0,74,2],[73,3,74,4],[73,5,74,8],[73,9,74,9],[73,10,74,10],[73,11,74,11],[77,0,77,2],[77,3,77,4],[77,5,77,8],[76,0,76,2],[76,3,76,4],[76,5,76,8],[86,1,86,2],[86,3,86,11],[87,0,88,2],[87,3,88,4],[87,5,88,8],[87,9,88,9],[87,10,88,10],[87,11,88,11],[79,0,79,2],[79,3,79,4],[79,5,79,8],[80,0,80,8],[82,0,83,11],[85,1,85,2],[85,3,85,11],[91,1,91,2],[91,3,91,4],[91,5,91,8],[92,0,92,8],[94,0,95,11],[96,0,96,1],[89,1,89,2],[89,3,89,4],[89,5,89,8],[90,1,90,2],[90,3,90,4],[90,5,90,8],[99,9,100,9],[99,10,100,10],[99,11,100,11],[101,0,101,1],[101,2,101,6],[101,7,101,8],[97,0,97,1],[97,2,97,6],[97,7,97,8],[97,9,98,11],[98,0,98,1],[98,2,98,6],[98,7,98,8],[103,0,103,8],[104,0,104,1],[105,1,105,2],[105,3,105,5],[105,6,105,11],[106,1,106,2],[106,3,106,5],[106,6,106,11],[102,0,102,1],[102,2,102,6],[102,7,102,8],[107,11,108,11],[109,1,109,2],[109,3,109,5],[110,1,110,2],[110,3,110,5],[111,1,111,2],[111,3,111,5],[107,0,108,5],[107,6,108,6],[107,7,108,7],[107,8,108,8],[107,9,108,9],[107,10,108,10],[118,0,118,1],[118,2,118,6],[118,7,118,8],[119,0,120,1],[119,9,120,9],[119,10,120,10],[112,0,112,8],[114,0,115,11],[116,0,116,1],[117,0,117,1],[117,2,117,6],[117,7,117,8],[126,0,126,1],[126,2,126,6],[126,7,126,8],[127,0,127,8],[128,0,128,1],[129,1,129,2],[129,3,129,5],[129,6,129,11],[119,11,120,11],[121,0,121,1],[121,2,121,6],[121,7,121,8],[125,0,125,1],[125,2,125,6],[125,7,125,8],[124,0,124,1],[124,2,124,6],[124,7,124,8],[123,0,123,1],[123,2,123,6],[123,7,123,8],[122,0,122,1],[122,2,122,6],[122,7,122,8],[130,1,130,2],[130,3,130,5],[130,6,130,11],[131,0,132,5],[131,6,132,6],[131,7,132,7],[131,8,132,8],[131,9,132,9],[131,10,132,10],[131,11,132,11],[136,0,136,8],[138,0,139,11],[141,0,141,1],[141,2,141,11],[142,0,142,1],[142,2,142,11],[133,1,133,2],[133,3,133,5],[134,1,134,2],[134,3,134,5],[135,1,135,2],[135,3,135,5],[153,0,153,2],[153,3,153,11],[154,0,154,2],[154,3,154,11],[155,0,156,2],[155,3,156,4],[155,5,156,8],[155,9,156,9],[155,10,156,10],[155,11,156,11],[147,0,147,1],[147,2,147,3],[147,5,147,6],[147,7,147,8],[148,0,148,8],[150,0,151,11],[143,11,144,11],[145,0,145,1],[145,2,145,3],[145,5,145,6],[145,7,145,8],[146,0,146,1],[146,2,146,3],[146,5,146,6],[146,7,146,8],[143,2,144,3],[143,4,144,4],[143,5,144,6],[143,7,144,8],[143,9,144,9],[143,10,144,10],[9,2,9,3],[9,5,9,6],[9,7,9,8],[159,0,159,2],[159,3,159,4],[159,5,159,8],[160,0,160,8],[162,0,163,11],[157,0,157,2],[157,3,157,4],[157,5,157,8],[11,2,11,3],[11,5,11,6],[11,7,11,8],[33,0,33,2],[33,3,33,4],[33,5,33,8],[32,3,32,4],[32,5,32,8],[31,3,31,4],[31,5,31,8],[30,3,30,4],[30,5,30,8],[29,3,29,4]]}
[{"$f":"'Budget Sheet Instructions'!A19","v":"Budget Detail - Year 3"}]
["Does this budget contain conference costs which is defined broadly to include meetings, retreats, seminars, symposia, and training activities? - Y/N",null,null,null,null,null,null,null,null,null,"Yes"]
["(DOJ Financial Guide, Section 3.10)"]
["A. Personnel"]
["Name","Position","Computation"]
["List each name, if known.","List each position, if known.","Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"Salary ",null,"Rate","Time Worked\n(# of hours, days, months, years)",null,"Percentage of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C9*F9*H9,1)","v":0},null,{"$f":"IF(J9-K9<0,0,J9-K9)","v":0}]
["Donna Michaelis","Grant oversight",99840,null,"yearly",1,null,0.1,null,{"$f":"CEILING(C10*F10*H10,1)","v":9984},9984,{"$f":"IF(J10-K10<0,0,J10-K10)","v":0}]
["Project Coordinator (TBD)","Project Coordinator",72800,null,"yearly",1,null,1,null,72800,null,72800]
["David Cotter","Legal Support",124800,null,"yearly",1,null,0.05,null,6240,6240,0]
["Marc Dawkins","Training Support",72800,null,"yearly",1,null,0.1,null,7280,7280,0]
["Shellie Evers","Communication, Procurement, and Training Support",64480,null,"yearly",1,null,0.15,null,9672,9672,0]
["Jim McDonough","Research Support",99840,null,"yearly",1,null,0.15,null,14976,14976,0]
["Grant Support Specialist (TBD)","Grant Support Specialist",31,null,"hourly",1490,null,1,null,46190,null,46190]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J17)","v":167142},{"$f":"SUM(K9:K17)","v":48152},{"$f":"SUM(L9:L17)","v":118990}]
["Narrative"]
["Donna Michaelis, Manager, will provide oversight on the entire award providing 10% of her time on the project. A Project coordinator and Gant Support Specialist will manage the project, facilitate trainings, complete reports and submit deliverables spending 100% of their time on the project. Dave Cotter, Attorney, will provide legal consultation in the development of the case management tool. Marc Dawkins, training coordinator will provide training facilitation, spending 10% of his time on the project. Shellie Evers, training coordinator and school safety specialist will provide communication, procurement, and training support, spending 15% of her time on this project.  Jim McDonough, researcher, will provide critical and ongoing data, and will spend 15% of his time on the project.   All staff support, with the exception of the Project Coordinator and Grant Support Specialist, are being offered in kind. Additional duties will be added to each position as needed to support this grant project.  Calculations are based on additional responsibilities and a percentage of salaries annually."]
[]
[]
["B. Fringe Benefits"]
["Name",null,null,"Computation"]
["List each grant-supported position receiving fringe benefits.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D28*F28,1)","v":0},null,{"$f":"IF(J28-K28<0,0,J28-K28)","v":0}]
["Grant Support Specialist (TBD",null,null,46190,null,7.6499999999999999E-2,null,null,null,{"$f":"CEILING(D29*F29,1)","v":3534},null,{"$f":"IF(J29-K29<0,0,J29-K29)","v":3534}]
["Donna Michaelis",null,null,9984,null,0.45,null,null,null,4493,4493,0]
["Project Coordinator (TBD)",null,null,72800,null,0.35,null,null,null,25480,null,25480]
["David Cotter",null,null,6240,null,0.45,null,null,null,2808,2808,0]
["Marc Dawkins",null,null,7280,null,0.45,null,null,null,3276,3276,0]
["Shellie Evers",null,null,9672,null,0.45,null,null,null,4353,4353,0]
["Jim McDonough",null,null,14976,null,0.45,null,null,null,6740,6740,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J28:J36)","v":50684},{"$f":"SUM(K28:K36)","v":21670},{"$f":"SUM(L28:L36)","v":29014}]
["Narrative"]
["DCJS' state fringe benefits rate is 45% and includes taxes, annual leave, FICA, health insurance, retirement, and long term disability.  The benefits fo for the coordinator are 35% and 7.65% for the part-time employee to cover Social Security and Workers Comp. Benefits are about 30% of the base before health insurance.  Medical/Hospitalization Insurance: includes expenditures of group medical/ hospitalization insurance program provided for the benefit of State employees and can vary based on status: Employee-$8,244; Employee plus 1-$14,748; and Family-$21,624.  This can add 12% to 30% more cost to the benefits percentage. \n\nThe benefits base of 30% is comprised of:\n\nFederal Old-Age Insurance for Salaried State Employees: Includes expenditures of Contribution Fund for old-age and survivors’ benefits for salaried State employees (social security). \n\nFederal Old-Age Insurance for Wage-Earning State Employees: Includes expenditures of Contribution Fund for old-age and survivors’ benefits for wage-earning State employees.\n\nEmployer Retirement Contributions - VRS Defined Benefits Program: Includes expenditures for payments made to the retirement system trust fund for a defined benefit program for salaried State employees.\n\nGroup Life Insurance: Includes expenditures of group life insurance program provided for the benefit of State employees.\n\nRetiree Medical/Hospitalization Insurance Credit: Includes expenditures for payments to the Retiree Health Insurance Fund. \n\nLong-term Disability Insurance: Includes expenditures of the long-term disability program provided for the benefit of state employees.\n\nDeferred Compensation Match Payments: Includes expenditures for employer match of the state employee deferred compensation program.  The maximum amount paid is 50% of employee contribution with a ceiling of $40.00 per month.  "]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense","Basis","Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Lodging, Meals, Etc.","Per day, mile, trip, Etc.","Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Quantity","# of Staff","# of Trips","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,{"$f":"IF((D47=\"Lodging\"),\"Night\",IF((D47=\"Meals\"),\"Day\",IF((D47=\"Mileage\"),\"Mile\",IF((D47=\"Transportation\"),\"Round-trip\",\"N/A\"))))","v":"N/A"},null,null,null,null,{"$f":"CEILING(F47*G47*H47*I47,1)","v":0},null,{"$f":"IF(J47-K47<0,0,J47-K47)","v":0}]
["DCJS Vehicle","varies",null,"mileage","Mile",0.57999999999999996,406,2,16,{"$f":"CEILING(F48*G48*H48*I48,1)","v":7536},7536,{"$f":"IF(J48-K48<0,0,J48-K48)","v":0}]
["K-12 Threat Assessment","Varies",null,"Meals","Day",51,2.5,1,16,2040,null,2040]
["K-12 Threat Assessment","Varies",null,"Lodging","Night",93,1,1,16,1488,null,1488]
["TTT Training","Varies",null,"Meals","Day",51,2.5,1,4,510,null,510]
["TTT Training","Varies",null,"Lodging","Night",93,1,1,4,372,null,372]
[null,null,null,null,"N/A",null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J47:J53)","v":11946},{"$f":"SUM(K47:K53)","v":7536},{"$f":"SUM(L47:L53)","v":4410}]
["Narrative"]
["DCJS will provide a state vehicle for travel to the training coordinator and program coordinator.  The coordinators will need access to a vehicle to meet with school division personnel and to attend and deliver training.  The vehicles will be tracked for in-kind matching purposes.  Mileage is based on the  coordinators attending and delivering the sixteen (16) trainings per year with an average roundtrip of 406 per training (406 miles x .58 per mile = $235 x 16 trainings = $3768). Per award guidelines, key members must attend orientation training in Washington, DC. We are following our own travel policy. Per-diem rates in DC are $69 for meals, and lodging varies from $175 to $225 based on the time of year.  Lodging is for 2 nights and meals are budgeted at 2.5 days as the two travel days are computed at .75 days. K-12 Lodging is for one night for 12 trainings at $93 standard rate and meals are budgeted standard rate of $51 at 1.5 days as the two travel days are computed at .75 days TTT training is for 2 nights for 4 sessions at $93 standard rate and meals are budgeted at the standard rate of $51 for 2.5 days as the two travel days are computed at .75 days."]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Unit Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D64*F64,1)","v":0},null,{"$f":"IF(J64-K64<0,0,J64-K64)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D65*F65,1)","v":0},null,{"$f":"IF(J65-K65<0,0,J65-K65)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D66*F66,1)","v":0},null,{"$f":"IF(J66-K66<0,0,J66-K66)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J64:J66)","v":0},{"$f":"SUM(K64:K66)","v":0},{"$f":"SUM(L64:L66)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Unit Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D76*F76,1)","v":0},null,{"$f":"IF(J76-K76<0,0,J76-K76)","v":0}]
["General Office Supplies",null,null,12,null,150,null,null,null,{"$f":"CEILING(D77*F77,1)","v":1800},null,{"$f":"IF(J77-K77<0,0,J77-K77)","v":1800}]
["Training Material for K-12 Training",null,null,640,null,7,null,null,null,{"$f":"CEILING(D78*F78,1)","v":4480},null,{"$f":"IF(J78-K78<0,0,J78-K78)","v":4480}]
["Training Materials for TTT Training",null,null,40,null,25,null,null,null,{"$f":"CEILING(D79*F79,1)","v":1000},null,{"$f":"IF(J79-K79<0,0,J79-K79)","v":1000}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D80*F80,1)","v":0},null,{"$f":"IF(J80-K80<0,0,J80-K80)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J76:J80)","v":7280},{"$f":"SUM(K76:K80)","v":0},{"$f":"SUM(L76:L80)","v":7280}]
["Narrative"]
["\nGeneral office supplies will be use by all personnel on this project and include: pens, pencils, paper, printer cartridges and general office supplies. The office supplies ar based on 12 months at $150 per month. This amount was determined based upon other projects of this size that we have completed. \nTraining material includes handouts, pens, and basic office supplies. The training supplies for K-12 Threat Assessment are based on a 16 training sessions with 40 participants per session. The training supplies for the TTT training are based on 4 trainings with 10 participants per session. These amounts were determined based upon other trainings that we have completed in the past. "]
[]
["F. Construction"]
["Purpose","Description of Work",null,"Computation"]
["Provide the purpose of the construction","Describe the construction project(s)",null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D90*F90,1)","v":0},null,{"$f":"IF(J90-K90<0,0,J90-K90)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D91*F91,1)","v":0},null,{"$f":"IF(J91-K91<0,0,J91-K91)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D92*F92,1)","v":0},null,{"$f":"IF(J92-K92<0,0,J92-K92)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J90:J92)","v":0},{"$f":"SUM(K90:K92)","v":0},{"$f":"SUM(L90:L92)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Description",null,"Purpose",null,null,null,null,"Consultant?"]
["Provide a description of the activities to be carried out by subrecipients.",null,"Describe the purpose of the subaward (subgrant)",null,null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost."]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J102-K102<0,0,J102-K102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J103-K103<0,0,J103-K103)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J102:J103)+J113","v":0},{"$f":"SUM(K102:K103)+K113","v":0},{"$f":"SUM(L102:L103)+L113","v":0}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G110*H110*I110,1)","v":0},null,{"$f":"IF(J110-K110<0,0,J110-K110)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G111*H111*I111,1)","v":0},null,{"$f":"IF(J111-K111<0,0,J111-K111)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G112*H112*I112,1)","v":0},null,{"$f":"IF(J112-K112<0,0,J112-K112)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J110:J112)","v":0},{"$f":"SUM(K110:K112)","v":0},{"$f":"SUM(L110:L112)","v":0}]
["Narrative"]
[" "]
[]
["H. Procurement Contracts"]
["Description",null,"Purpose",null,null,null,null,"Consultant?"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000). ",null,"Describe the purpose of the contract",null,null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost."]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J122-K122<0,0,J122-K122)","v":0}]
["Consultant TBD",null,"Provide access to technical assistance as school divisions implement threat assessment processes",null,null,null,null,"Yes",null,4800,null,4800]
["K-12 Threat Assessment Training ",null,"Provide training in behavioral threat assessment to threat assessment teams across the Commonwealth. ",null,null,null,null,"No",null,64000,16000,48000]
["Train the Trainer - K-12 Threat Assessment",null,"train school personnel  to teach threat assessment training",null,null,null,null,"No",null,32000,null,32000]
["Case Management Tool",null,"Develop an on-line case management tool that will facilitate process development, data collection and case management",null,null,null,null,"No",null,20000,null,20000]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J122:J127)+J137","v":120800},{"$f":"SUM(K122:K127)+K137","v":16000},{"$f":"SUM(L122:L127)+L137","v":104800}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G134*H134*I134,1)","v":0},null,{"$f":"IF(J134-K134<0,0,J134-K134)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G135*H135*I135,1)","v":0},null,{"$f":"IF(J135-K135<0,0,J135-K135)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G136*H136*I136,1)","v":0},null,{"$f":"IF(J136-K136<0,0,J136-K136)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J134:J136)","v":0},{"$f":"SUM(K134:K136)","v":0},{"$f":"SUM(L134:L136)","v":0}]
["Narrative"]
["DCJS will utilize an RFP process to identify a vendor to provide 60 hours of consultation services to school divisions.  The rate is expected to be $80 per hour based on a previous project.  DCJS will use the RFP process to identify a vendor to adapt the DCJS training curriculum to include activities to directly support school divisions to identify and strengthen their existing threat assessment processes.  The vendor will then provide the trainings to targeted school divisions. DCJS will utilize the RFP process to hire a vendor to present the DCJS Train the Trainer curriculum. The project coordinator will work with the vendor to adapt the current curriculum to match the updated K-12 threat assessment curriculum.  DCJS will use the RFP process to identify a vendor to create the case management tool. "]
[]
["I. Other Costs"]
["Description ",null,"Computation"]
["List and describe items that will be paid with grants funds (e.g. rent, reproduction, telephone, janitorial, or security services, and investigative or confidential funds).",null,"Show the basis for computation"]
[null,null,"Quantity",null,"Basis","Cost",null,"Length of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C146*F146*H146,1)","v":0},null,{"$f":"IF(J146-K146<0,0,J146-K146)","v":0}]
["School Safety Survey",null,1,null,null,5400,null,1,null,{"$f":"CEILING(C147*F147*H147,1)","v":5400},5400,{"$f":"IF(J147-K147<0,0,J147-K147)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C148*F148*H148,1)","v":0},null,{"$f":"IF(J148-K148<0,0,J148-K148)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J146:J148)","v":5400},{"$f":"SUM(K146:K148)","v":5400},{"$f":"SUM(L146:L148)","v":0}]
["Narrative"]
["In the Commonwealth of Virginia, all public schools are required to conduct an annual school safety audit in order to assess school safety conditions. Through enabling legislation (legislation (§ 9.1-184), the Virginia Center for School and Campus Safety (VCSCS) has been designated to collect, analyze, and disseminate various Virginia school safety data including school safety audit information. In 2005, the General Assembly transferred the authority to collect school safety audit information from the Department of Education to the Department of Criminal Justice Services. To date, the VCSCS has developed five components for the school safety audit program: Virginia School Safety Survey, the Division Level Survey,  Virginia School Crisis Management Plan Review and Certification, Virginia Secondary School Climate Survey, and the School Safety Inspection Checklist (due every three years; next due date August 2020).  This cost is associated with the printing and dissemination of this document to support the work of threat assessment teams."]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D158*F158,1)","v":0},null,{"$f":"IF(J158-K158<0,0,J158-K158)","v":0}]
["Indirect Cost Rate Agreemnet (Attached",null,null,218004,null,3.984E-2,null,null,null,{"$f":"CEILING(D159*F159,1)","v":8686},null,{"$f":"IF(J159-K159<0,0,J159-K159)","v":8686}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D160*F160,1)","v":0},null,{"$f":"IF(J160-K160<0,0,J160-K160)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J158:J160)","v":8686},{"$f":"SUM(K158:K160)","v":0},{"$f":"SUM(L158:L160)","v":8686}]
["Narrative"]
["DCJS has a federally negotiated Indirect Cost Rate Agreemnet (Attached) of 17.55% for FY2019 and 15.62% for FY2020.  For the purposes of this grant we are only applying 3.98% against the negotiated salries and wages base.  A copy of the Department of Justice negotiated agreement letter is attached.  Should we realize a cost savings or need to charge more of the rate we will submit a budget modification request in accoradnce with 2 CFR § 200.414. "]

{"sheet":"Budget Detail - Year 4","index":5,"n_rows":139,"n_cols":12,"rows_kept":139,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,7,0,11],[1,0,1,9],[1,10,2,11],[2,0,2,1],[4,2,4,11],[8,2,8,3],[8,5,8,6],[8,7,8,8],[9,2,9,3],[9,5,9,6],[9,7,9,8],[5,2,5,11],[6,0,7,1],[6,2,7,3],[6,4,7,4],[6,5,7,6],[6,7,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[17,0,17,2],[17,3,17,11],[18,0,19,2],[18,3,19,4],[18,5,19,8],[18,9,19,9],[18,10,19,10],[18,11,19,11],[10,2,10,3],[10,5,10,6],[10,7,10,8],[11,0,11,8],[13,0,14,11],[16,0,16,2],[16,3,16,11],[22,0,22,2],[22,3,22,4],[22,5,22,8],[23,0,23,8],[25,0,26,11],[28,1,28,2],[28,5,28,11],[20,0,20,2],[20,3,20,4],[20,5,20,8],[21,0,21,2],[21,3,21,4],[21,5,21,8],[29,1,29,2],[29,5,29,11],[30,0,31,4],[30,5,31,5],[30,6,31,6],[30,7,31,7],[30,8,31,8],[30,9,31,9],[30,10,31,10],[30,11,31,11],[41,0,41,2],[41,3,41,11],[42,0,43,2],[42,3,43,4],[42,5,43,8],[42,9,43,9],[42,10,43,10],[42,11,43,11],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,0,35,8],[37,0,38,11],[40,0,40,2],[40,3,40,11],[46,0,46,2],[46,3,46,4],[46,5,46,8],[47,0,47,8],[49,0,50,11],[52,0,52,2],[52,3,52,11],[44,0,44,2],[44,3,44,4],[44,5,44,8],[45,0,45,2],[45,3,45,4],[45,5,45,8],[56,0,56,2],[56,3,56,4],[56,5,56,8],[57,0,57,2],[57,3,57,4],[57,5,57,8],[53,0,53,2],[53,3,53,11],[54,0,55,2],[54,3,55,4],[54,5,55,8],[54,9,55,9],[54,10,55,10],[54,11,55,11],[65,1,65,2],[65,3,65,11],[66,0,67,2],[66,3,67,4],[66,5,67,8],[66,9,67,9],[66,10,67,10],[66,11,67,11],[58,0,58,2],[58,3,58,4],[58,5,58,8],[59,0,59,8],[61,0,62,11],[64,1,64,2],[64,3,64,11],[70,1,70,2],[70,3,70,4],[70,5,70,8],[71,0,71,8],[73,0,74,11],[75,0,75,1],[68,1,68,2],[68,3,68,4],[68,5,68,8],[69,1,69,2],[69,3,69,4],[69,5,69,8],[78,9,79,9],[78,10,79,10],[78,11,79,11],[80,0,80,1],[80,2,80,6],[80,7,80,8],[76,0,76,1],[76,2,76,6],[76,7,76,8],[76,9,77,11],[77,0,77,1],[77,2,77,6],[77,7,77,8],[83,0,83,8],[84,0,84,1],[85,1,85,2],[85,3,85,5],[85,6,85,11],[86,1,86,2],[86,3,86,5],[86,6,86,11],[81,0,81,1],[81,2,81,6],[81,7,81,8],[82,0,82,1],[82,2,82,6],[82,7,82,8],[87,11,88,11],[89,1,89,2],[89,3,89,5],[90,1,90,2],[90,3,90,5],[91,1,91,2],[91,3,91,5],[87,0,88,5],[87,6,88,6],[87,7,88,7],[87,8,88,8],[87,9,88,9],[87,10,88,10],[98,0,98,1],[98,2,98,6],[98,7,98,8],[99,0,100,1],[99,9,100,9],[99,10,100,10],[92,0,92,8],[94,0,95,11],[96,0,96,1],[97,0,97,1],[97,2,97,6],[97,7,97,8],[103,0,103,1],[103,2,103,6],[103,7,103,8],[104,0,104,8],[105,0,105,1],[106,1,106,2],[106,3,106,5],[106,6,106,11],[99,11,100,11],[101,0,101,1],[101,2,101,6],[101,7,101,8],[102,0,102,1],[102,2,102,6],[102,7,102,8],[107,1,107,2],[107,3,107,5],[107,6,107,11],[108,0,109,5],[108,6,109,6],[108,7,109,7],[108,8,109,8],[108,9,109,9],[108,10,109,10],[108,11,109,11],[113,0,113,8],[115,0,116,11],[118,0,118,1],[118,2,118,11],[119,0,119,1],[119,2,119,11],[110,1,110,2],[110,3,110,5],[111,1,111,2],[111,3,111,5],[112,1,112,2],[112,3,112,5],[124,0,124,1],[124,2,124,3],[124,5,124,6],[124,7,124,8],[125,0,125,8],[127,0,128,11],[120,11,121,11],[122,0,122,1],[122,2,122,3],[122,5,122,6],[122,7,122,8],[123,0,123,1],[123,2,123,3],[123,5,123,6],[123,7,123,8],[120,2,121,3],[120,4,121,4],[120,5,121,6],[120,7,121,8],[120,9,121,9],[120,10,121,10],[130,0,130,2],[130,3,130,11],[131,0,131,2],[131,3,131,11],[132,0,133,2],[132,3,133,4],[132,5,133,8],[132,9,133,9],[132,10,133,10],[132,11,133,11],[136,0,136,2],[136,3,136,4],[136,5,136,8],[137,0,137,8],[139,0,140,11],[134,0,134,2],[134,3,134,4],[134,5,134,8],[135,0,135,2],[135,3,135,4],[135,5,135,8]]}
[{"$f":"'Budget Sheet Instructions'!A20","v":"Budget Detail - Year 4"}]
["Does this budget contain conference costs which is defined broadly to include meetings, retreats, seminars, symposia, and training activities? - Y/N"]
["(DOJ Financial Guide, Section 3.10)"]
["A. Personnel"]
["Name","Position","Computation"]
["List each name, if known.","List each position, if known.","Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"Salary ",null,"Rate","Time Worked\n(# of hours, days, months, years)",null,"Percentage of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C9*F9*H9,1)","v":0},null,{"$f":"IF(J9-K9<0,0,J9-K9)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C10*F10*H10,1)","v":0},null,{"$f":"IF(J10-K10<0,0,J10-K10)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C11*F11*H11,1)","v":0},null,{"$f":"IF(J11-K11<0,0,J11-K11)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J11)","v":0},{"$f":"SUM(K9:K11)","v":0},{"$f":"SUM(L9:L11)","v":0}]
["Narrative"]
[]
[]
["B. Fringe Benefits"]
["Name",null,null,"Computation"]
["List each grant-supported position receiving fringe benefits.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D21*F21,1)","v":0},null,{"$f":"IF(J21-K21<0,0,J21-K21)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D22*F22,1)","v":0},null,{"$f":"IF(J22-K22<0,0,J22-K22)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D23*F23,1)","v":0},null,{"$f":"IF(J23-K23<0,0,J23-K23)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J21:J23)","v":0},{"$f":"SUM(K21:K23)","v":0},{"$f":"SUM(L21:L23)","v":0}]
["Narrative"]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense","Basis","Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Lodging, Meals, Etc.","Per day, mile, trip, Etc.","Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Quantity","# of Staff","# of Trips","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,{"$f":"IF((D33=\"Lodging\"),\"Night\",IF((D33=\"Meals\"),\"Day\",IF((D33=\"Mileage\"),\"Mile\",IF((D33=\"Transportation\"),\"Round-trip\",\"N/A\"))))","v":"N/A"},null,null,null,null,{"$f":"CEILING(F33*G33*H33*I33,1)","v":0},null,{"$f":"IF(J33-K33<0,0,J33-K33)","v":0}]
[null,null,null,null,{"$f":"IF((D34=\"Lodging\"),\"Night\",IF((D34=\"Meals\"),\"Day\",IF((D34=\"Mileage\"),\"Mile\",IF((D34=\"Transportation\"),\"Round-trip\",\"N/A\"))))","v":"N/A"},null,null,null,null,{"$f":"CEILING(F34*G34*H34*I34,1)","v":0},null,{"$f":"IF(J34-K34<0,0,J34-K34)","v":0}]
[null,null,null,null,{"$f":"IF((D35=\"Lodging\"),\"Night\",IF((D35=\"Meals\"),\"Day\",IF((D35=\"Mileage\"),\"Mile\",IF((D35=\"Transportation\"),\"Round-trip\",\"N/A\"))))","v":"N/A"},null,null,null,null,{"$f":"CEILING(F35*G35*H35*I35,1)","v":0},null,{"$f":"IF(J35-K35<0,0,J35-K35)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J33:J35)","v":0},{"$f":"SUM(K33:K35)","v":0},{"$f":"SUM(L33:L35)","v":0}]
["Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Unit Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D45*F45,1)","v":0},null,{"$f":"IF(J45-K45<0,0,J45-K45)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D46*F46,1)","v":0},null,{"$f":"IF(J46-K46<0,0,J46-K46)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D47*F47,1)","v":0},null,{"$f":"IF(J47-K47<0,0,J47-K47)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J45:J47)","v":0},{"$f":"SUM(K45:K47)","v":0},{"$f":"SUM(L45:L47)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Unit Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D57*F57,1)","v":0},null,{"$f":"IF(J57-K57<0,0,J57-K57)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D58*F58,1)","v":0},null,{"$f":"IF(J58-K58<0,0,J58-K58)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D59*F59,1)","v":0},null,{"$f":"IF(J59-K59<0,0,J59-K59)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J57:J59)","v":0},{"$f":"SUM(K57:K59)","v":0},{"$f":"SUM(L57:L59)","v":0}]
["Narrative"]
[]
[]
["F. Construction"]
["Purpose","Description of Work",null,"Computation"]
["Provide the purpose of the construction","Describe the construction project(s)",null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D69*F69,1)","v":0},null,{"$f":"IF(J69-K69<0,0,J69-K69)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D70*F70,1)","v":0},null,{"$f":"IF(J70-K70<0,0,J70-K70)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D71*F71,1)","v":0},null,{"$f":"IF(J71-K71<0,0,J71-K71)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J69:J71)","v":0},{"$f":"SUM(K69:K71)","v":0},{"$f":"SUM(L69:L71)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Description",null,"Purpose",null,null,null,null,"Consultant?"]
["Provide a description of the activities to be carried out by subrecipients.",null,"Describe the purpose of the subaward (subgrant)",null,null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost."]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J81-K81<0,0,J81-K81)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J82-K82<0,0,J82-K82)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J83-K83<0,0,J83-K83)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J81:J83)+J93","v":0},{"$f":"SUM(K81:K83)+K93","v":0},{"$f":"SUM(L81:L83)+L93","v":0}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G90*H90*I90,1)","v":0},null,{"$f":"IF(J90-K90<0,0,J90-K90)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G91*H91*I91,1)","v":0},null,{"$f":"IF(J91-K91<0,0,J91-K91)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G92*H92*I92,1)","v":0},null,{"$f":"IF(J92-K92<0,0,J92-K92)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J90:J92)","v":0},{"$f":"SUM(K90:K92)","v":0},{"$f":"SUM(L90:L92)","v":0}]
["Narrative"]
[]
[]
["H. Procurement Contracts"]
["Description",null,"Purpose",null,null,null,null,"Consultant?"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000). ",null,"Describe the purpose of the contract",null,null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost."]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J102-K102<0,0,J102-K102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J103-K103<0,0,J103-K103)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J104-K104<0,0,J104-K104)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J102:J104)+J114","v":0},{"$f":"SUM(K102:K104)+K114","v":0},{"$f":"SUM(L102:L104)+L114","v":0}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G111*H111*I111,1)","v":0},null,{"$f":"IF(J111-K111<0,0,J111-K111)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G112*H112*I112,1)","v":0},null,{"$f":"IF(J112-K112<0,0,J112-K112)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G113*H113*I113,1)","v":0},null,{"$f":"IF(J113-K113<0,0,J113-K113)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J111:J113)","v":0},{"$f":"SUM(K111:K113)","v":0},{"$f":"SUM(L111:L113)","v":0}]
["Narrative"]
[]
[]
["I. Other Costs"]
["Description ",null,"Computation"]
["List and describe items that will be paid with grants funds (e.g. rent, reproduction, telephone, janitorial, or security services, and investigative or confidential funds).",null,"Show the basis for computation"]
[null,null,"Quantity",null,"Basis","Cost",null,"Length of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C123*F123*H123,1)","v":0},null,{"$f":"IF(J123-K123<0,0,J123-K123)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C124*F124*H124,1)","v":0},null,{"$f":"IF(J124-K124<0,0,J124-K124)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C125*F125*H125,1)","v":0},null,{"$f":"IF(J125-K125<0,0,J125-K125)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J123:J125)","v":0},{"$f":"SUM(K123:K125)","v":0},{"$f":"SUM(L123:L125)","v":0}]
["Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D135*F135,1)","v":0},null,{"$f":"IF(J135-K135<0,0,J135-K135)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D136*F136,1)","v":0},null,{"$f":"IF(J136-K136<0,0,J136-K136)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D137*F137,1)","v":0},null,{"$f":"IF(J137-K137<0,0,J137-K137)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J135:J137)","v":0},{"$f":"SUM(K135:K137)","v":0},{"$f":"SUM(L135:L137)","v":0}]
["Narrative"]

{"sheet":"Budget Detail - Year 5","index":6,"n_rows":139,"n_cols":12,"rows_kept":139,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,7,0,11],[1,0,1,9],[1,10,2,11],[2,0,2,1],[4,2,4,11],[8,2,8,3],[8,5,8,6],[8,7,8,8],[9,2,9,3],[9,5,9,6],[9,7,9,8],[5,2,5,11],[6,0,7,1],[6,2,7,3],[6,4,7,4],[6,5,7,6],[6,7,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[17,0,17,2],[17,3,17,11],[18,0,19,2],[18,3,19,4],[18,5,19,8],[18,9,19,9],[18,10,19,10],[18,11,19,11],[10,2,10,3],[10,5,10,6],[10,7,10,8],[11,0,11,8],[13,0,14,11],[16,0,16,2],[16,3,16,11],[22,0,22,2],[22,3,22,4],[22,5,22,8],[23,0,23,8],[25,0,26,11],[28,1,28,2],[28,5,28,11],[20,0,20,2],[20,3,20,4],[20,5,20,8],[21,0,21,2],[21,3,21,4],[21,5,21,8],[29,1,29,2],[29,5,29,11],[30,0,31,4],[30,5,31,5],[30,6,31,6],[30,7,31,7],[30,8,31,8],[30,9,31,9],[30,10,31,10],[30,11,31,11],[41,0,41,2],[41,3,41,11],[42,0,43,2],[42,3,43,4],[42,5,43,8],[42,9,43,9],[42,10,43,10],[42,11,43,11],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,0,35,8],[37,0,38,11],[40,0,40,2],[40,3,40,11],[46,0,46,2],[46,3,46,4],[46,5,46,8],[47,0,47,8],[49,0,50,11],[52,0,52,2],[52,3,52,11],[44,0,44,2],[44,3,44,4],[44,5,44,8],[45,0,45,2],[45,3,45,4],[45,5,45,8],[56,0,56,2],[56,3,56,4],[56,5,56,8],[57,0,57,2],[57,3,57,4],[57,5,57,8],[53,0,53,2],[53,3,53,11],[54,0,55,2],[54,3,55,4],[54,5,55,8],[54,9,55,9],[54,10,55,10],[54,11,55,11],[65,1,65,2],[65,3,65,11],[66,0,67,2],[66,3,67,4],[66,5,67,8],[66,9,67,9],[66,10,67,10],[66,11,67,11],[58,0,58,2],[58,3,58,4],[58,5,58,8],[59,0,59,8],[61,0,62,11],[64,1,64,2],[64,3,64,11],[70,1,70,2],[70,3,70,4],[70,5,70,8],[71,0,71,8],[73,0,74,11],[75,0,75,1],[68,1,68,2],[68,3,68,4],[68,5,68,8],[69,1,69,2],[69,3,69,4],[69,5,69,8],[78,9,79,9],[78,10,79,10],[78,11,79,11],[80,0,80,1],[80,2,80,6],[80,7,80,8],[76,0,76,1],[76,2,76,6],[76,7,76,8],[76,9,77,11],[77,0,77,1],[77,2,77,6],[77,7,77,8],[83,0,83,8],[84,0,84,1],[85,1,85,2],[85,3,85,5],[85,6,85,11],[86,1,86,2],[86,3,86,5],[86,6,86,11],[81,0,81,1],[81,2,81,6],[81,7,81,8],[82,0,82,1],[82,2,82,6],[82,7,82,8],[87,11,88,11],[89,1,89,2],[89,3,89,5],[90,1,90,2],[90,3,90,5],[91,1,91,2],[91,3,91,5],[87,0,88,5],[87,6,88,6],[87,7,88,7],[87,8,88,8],[87,9,88,9],[87,10,88,10],[98,0,98,1],[98,2,98,6],[98,7,98,8],[99,0,100,1],[99,9,100,9],[99,10,100,10],[92,0,92,8],[94,0,95,11],[96,0,96,1],[97,0,97,1],[97,2,97,6],[97,7,97,8],[103,0,103,1],[103,2,103,6],[103,7,103,8],[104,0,104,8],[105,0,105,1],[106,1,106,2],[106,3,106,5],[106,6,106,11],[99,11,100,11],[101,0,101,1],[101,2,101,6],[101,7,101,8],[102,0,102,1],[102,2,102,6],[102,7,102,8],[107,1,107,2],[107,3,107,5],[107,6,107,11],[108,0,109,5],[108,6,109,6],[108,7,109,7],[108,8,109,8],[108,9,109,9],[108,10,109,10],[108,11,109,11],[113,0,113,8],[115,0,116,11],[118,0,118,1],[118,2,118,11],[119,0,119,1],[119,2,119,11],[110,1,110,2],[110,3,110,5],[111,1,111,2],[111,3,111,5],[112,1,112,2],[112,3,112,5],[124,0,124,1],[124,2,124,3],[124,5,124,6],[124,7,124,8],[125,0,125,8],[127,0,128,11],[120,11,121,11],[122,0,122,1],[122,2,122,3],[122,5,122,6],[122,7,122,8],[123,0,123,1],[123,2,123,3],[123,5,123,6],[123,7,123,8],[120,2,121,3],[120,4,121,4],[120,5,121,6],[120,7,121,8],[120,9,121,9],[120,10,121,10],[130,0,130,2],[130,3,130,11],[131,0,131,2],[131,3,131,11],[132,0,133,2],[132,3,133,4],[132,5,133,8],[132,9,133,9],[132,10,133,10],[132,11,133,11],[136,0,136,2],[136,3,136,4],[136,5,136,8],[137,0,137,8],[139,0,140,11],[134,0,134,2],[134,3,134,4],[134,5,134,8],[135,0,135,2],[135,3,135,4],[135,5,135,8]]}
[{"$f":"'Budget Sheet Instructions'!A21","v":"Budget Detail - Year 5"}]
["Does this budget contain conference costs which is defined broadly to include meetings, retreats, seminars, symposia, and training activities? - Y/N"]
["(DOJ Financial Guide, Section 3.10)"]
["A. Personnel"]
["Name","Position","Computation"]
["List each name, if known.","List each position, if known.","Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"Salary ",null,"Rate","Time Worked\n(# of hours, days, months, years)",null,"Percentage of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C9*F9*H9,1)","v":0},null,{"$f":"IF(J9-K9<0,0,J9-K9)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C10*F10*H10,1)","v":0},null,{"$f":"IF(J10-K10<0,0,J10-K10)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C11*F11*H11,1)","v":0},null,{"$f":"IF(J11-K11<0,0,J11-K11)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J11)","v":0},{"$f":"SUM(K9:K11)","v":0},{"$f":"SUM(L9:L11)","v":0}]
["Narrative"]
[]
[]
["B. Fringe Benefits"]
["Name",null,null,"Computation"]
["List each grant-supported position receiving fringe benefits.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D21*F21,1)","v":0},null,{"$f":"IF(J21-K21<0,0,J21-K21)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D22*F22,1)","v":0},null,{"$f":"IF(J22-K22<0,0,J22-K22)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D23*F23,1)","v":0},null,{"$f":"IF(J23-K23<0,0,J23-K23)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J21:J23)","v":0},{"$f":"SUM(K21:K23)","v":0},{"$f":"SUM(L21:L23)","v":0}]
["Narrative"]
[]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense","Basis","Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Lodging, Meals, Etc.","Per day, mile, trip, Etc.","Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Quantity","# of Staff","# of Trips","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,{"$f":"IF((D33=\"Lodging\"),\"Night\",IF((D33=\"Meals\"),\"Day\",IF((D33=\"Mileage\"),\"Mile\",IF((D33=\"Transportation\"),\"Round-trip\",\"N/A\"))))","v":"N/A"},null,null,null,null,{"$f":"CEILING(F33*G33*H33*I33,1)","v":0},null,{"$f":"IF(J33-K33<0,0,J33-K33)","v":0}]
[null,null,null,null,{"$f":"IF((D34=\"Lodging\"),\"Night\",IF((D34=\"Meals\"),\"Day\",IF((D34=\"Mileage\"),\"Mile\",IF((D34=\"Transportation\"),\"Round-trip\",\"N/A\"))))","v":"N/A"},null,null,null,null,{"$f":"CEILING(F34*G34*H34*I34,1)","v":0},null,{"$f":"IF(J34-K34<0,0,J34-K34)","v":0}]
[null,null,null,null,{"$f":"IF((D35=\"Lodging\"),\"Night\",IF((D35=\"Meals\"),\"Day\",IF((D35=\"Mileage\"),\"Mile\",IF((D35=\"Transportation\"),\"Round-trip\",\"N/A\"))))","v":"N/A"},null,null,null,null,{"$f":"CEILING(F35*G35*H35*I35,1)","v":0},null,{"$f":"IF(J35-K35<0,0,J35-K35)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J33:J35)","v":0},{"$f":"SUM(K33:K35)","v":0},{"$f":"SUM(L33:L35)","v":0}]
["Narrative"]
[]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Unit Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D45*F45,1)","v":0},null,{"$f":"IF(J45-K45<0,0,J45-K45)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D46*F46,1)","v":0},null,{"$f":"IF(J46-K46<0,0,J46-K46)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D47*F47,1)","v":0},null,{"$f":"IF(J47-K47<0,0,J47-K47)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J45:J47)","v":0},{"$f":"SUM(K45:K47)","v":0},{"$f":"SUM(L45:L47)","v":0}]
["Narrative"]
[]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Unit Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D57*F57,1)","v":0},null,{"$f":"IF(J57-K57<0,0,J57-K57)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D58*F58,1)","v":0},null,{"$f":"IF(J58-K58<0,0,J58-K58)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D59*F59,1)","v":0},null,{"$f":"IF(J59-K59<0,0,J59-K59)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J57:J59)","v":0},{"$f":"SUM(K57:K59)","v":0},{"$f":"SUM(L57:L59)","v":0}]
["Narrative"]
[]
[]
["F. Construction"]
["Purpose","Description of Work",null,"Computation"]
["Provide the purpose of the construction","Describe the construction project(s)",null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D69*F69,1)","v":0},null,{"$f":"IF(J69-K69<0,0,J69-K69)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D70*F70,1)","v":0},null,{"$f":"IF(J70-K70<0,0,J70-K70)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D71*F71,1)","v":0},null,{"$f":"IF(J71-K71<0,0,J71-K71)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J69:J71)","v":0},{"$f":"SUM(K69:K71)","v":0},{"$f":"SUM(L69:L71)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Description",null,"Purpose",null,null,null,null,"Consultant?"]
["Provide a description of the activities to be carried out by subrecipients.",null,"Describe the purpose of the subaward (subgrant)",null,null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost."]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J81-K81<0,0,J81-K81)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J82-K82<0,0,J82-K82)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J83-K83<0,0,J83-K83)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J81:J83)+J93","v":0},{"$f":"SUM(K81:K83)+K93","v":0},{"$f":"SUM(L81:L83)+L93","v":0}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G90*H90*I90,1)","v":0},null,{"$f":"IF(J90-K90<0,0,J90-K90)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G91*H91*I91,1)","v":0},null,{"$f":"IF(J91-K91<0,0,J91-K91)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G92*H92*I92,1)","v":0},null,{"$f":"IF(J92-K92<0,0,J92-K92)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J90:J92)","v":0},{"$f":"SUM(K90:K92)","v":0},{"$f":"SUM(L90:L92)","v":0}]
["Narrative"]
[]
[]
["H. Procurement Contracts"]
["Description",null,"Purpose",null,null,null,null,"Consultant?"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000). ",null,"Describe the purpose of the contract",null,null,null,null,"Is the subaward for a consultant? If yes, use the section below to explain associated travel expenses included in the cost."]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J102-K102<0,0,J102-K102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J103-K103<0,0,J103-K103)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J104-K104<0,0,J104-K104)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J102:J104)+J114","v":0},{"$f":"SUM(K102:K104)+K114","v":0},{"$f":"SUM(L102:L104)+L114","v":0}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G111*H111*I111,1)","v":0},null,{"$f":"IF(J111-K111<0,0,J111-K111)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G112*H112*I112,1)","v":0},null,{"$f":"IF(J112-K112<0,0,J112-K112)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G113*H113*I113,1)","v":0},null,{"$f":"IF(J113-K113<0,0,J113-K113)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J111:J113)","v":0},{"$f":"SUM(K111:K113)","v":0},{"$f":"SUM(L111:L113)","v":0}]
["Narrative"]
[]
[]
["I. Other Costs"]
["Description ",null,"Computation"]
["List and describe items that will be paid with grants funds (e.g. rent, reproduction, telephone, janitorial, or security services, and investigative or confidential funds).",null,"Show the basis for computation"]
[null,null,"Quantity",null,"Basis","Cost",null,"Length of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C123*F123*H123,1)","v":0},null,{"$f":"IF(J123-K123<0,0,J123-K123)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C124*F124*H124,1)","v":0},null,{"$f":"IF(J124-K124<0,0,J124-K124)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C125*F125*H125,1)","v":0},null,{"$f":"IF(J125-K125<0,0,J125-K125)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J123:J125)","v":0},{"$f":"SUM(K123:K125)","v":0},{"$f":"SUM(L123:L125)","v":0}]
["Narrative"]
[]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D135*F135,1)","v":0},null,{"$f":"IF(J135-K135<0,0,J135-K135)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D136*F136,1)","v":0},null,{"$f":"IF(J136-K136<0,0,J136-K136)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D137*F137,1)","v":0},null,{"$f":"IF(J137-K137<0,0,J137-K137)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J135:J137)","v":0},{"$f":"SUM(K135:K137)","v":0},{"$f":"SUM(L135:L137)","v":0}]
["Narrative"]

{"sheet":"Budget Summary","index":7,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[3,2,6,2],[3,11,6,11],[3,1,6,1],[2,1,2,2],[2,3,2,4],[3,3,6,3],[3,4,6,4],[2,5,2,6],[3,5,6,5],[3,6,6,6],[2,7,2,8],[3,7,6,7],[3,8,6,8],[21,0,21,8],[21,9,21,11],[2,9,2,10],[3,9,6,9],[3,10,6,10],[3,0,6,0]]}
["Budget Summary"]
["Note: Any errors detected on this page should be fixed on the corresponding Budget Detail tab."]
[null,"Year 1",null,"Year 2\n(if needed)",null,"Year 3\n(if needed)",null,"Year 4\n(if needed)",null,"Year 5\n(if needed)"]
["Budget Category","Federal Request","Non-Federal Request","Federal Request","Non-Federal Request","Federal Request","Non-Federal Request","Federal Request","Non-Federal Request","Federal Request","Non-Federal Request","Total(s)"]
[]
[]
[]
["A. Personnel",{"$f":"'Budget Detail - Year 1'!L18","v":118990},{"$f":"'Budget Detail - Year 1'!K18","v":48152},{"$f":"'Budget Detail - Year 2'!L18","v":118990},{"$f":"'Budget Detail - Year 2'!K18","v":48152},{"$f":"'Budget Detail - Year 3'!L18","v":118990},{"$f":"'Budget Detail - Year 3'!K18","v":48152},{"$f":"'Budget Detail - Year 4'!L12","v":0},{"$f":"'Budget Detail - Year 4'!K12","v":0},{"$f":"'Budget Detail - Year 5'!L12","v":0},{"$f":"'Budget Detail - Year 5'!K12","v":0},{"$f":"SUM(B8:K8)","v":501426}]
["B. Fringe Benefits",{"$f":"'Budget Detail - Year 1'!L38","v":29014},{"$f":"'Budget Detail - Year 1'!K38","v":21670},{"$f":"'Budget Detail - Year 2'!L38","v":29014},{"$f":"'Budget Detail - Year 2'!K38","v":21670},{"$f":"'Budget Detail - Year 3'!L37","v":29014},{"$f":"'Budget Detail - Year 3'!K37","v":21670},{"$f":"'Budget Detail - Year 4'!L24","v":0},{"$f":"'Budget Detail - Year 4'!K24","v":0},{"$f":"'Budget Detail - Year 5'!L24","v":0},{"$f":"'Budget Detail - Year 5'!K24","v":0},152052]
["C. Travel",{"$f":"'Budget Detail - Year 1'!L61","v":5156},{"$f":"'Budget Detail - Year 1'!K61","v":7536},{"$f":"'Budget Detail - Year 2'!L55","v":8550},{"$f":"'Budget Detail - Year 2'!K55","v":3768},{"$f":"'Budget Detail - Year 3'!L54","v":4410},{"$f":"'Budget Detail - Year 3'!K54","v":7536},{"$f":"'Budget Detail - Year 4'!L36","v":0},{"$f":"'Budget Detail - Year 4'!K36","v":0},{"$f":"'Budget Detail - Year 5'!L36","v":0},{"$f":"'Budget Detail - Year 5'!K36","v":0},36956]
["D. Equipment",{"$f":"'Budget Detail - Year 1'!L77","v":0},{"$f":"'Budget Detail - Year 1'!K77","v":2100},{"$f":"'Budget Detail - Year 2'!L69","v":0},{"$f":"'Budget Detail - Year 2'!K69","v":0},{"$f":"'Budget Detail - Year 3'!L67","v":0},{"$f":"'Budget Detail - Year 3'!K67","v":0},{"$f":"'Budget Detail - Year 4'!L48","v":0},{"$f":"'Budget Detail - Year 4'!K48","v":0},{"$f":"'Budget Detail - Year 5'!L48","v":0},{"$f":"'Budget Detail - Year 5'!K48","v":0},2100]
["E. Supplies",{"$f":"'Budget Detail - Year 1'!L92","v":4360},{"$f":"'Budget Detail - Year 1'!K92","v":760},{"$f":"'Budget Detail - Year 2'!L83","v":7280},{"$f":"'Budget Detail - Year 2'!K83","v":0},{"$f":"'Budget Detail - Year 3'!L81","v":7280},{"$f":"'Budget Detail - Year 3'!K81","v":0},{"$f":"'Budget Detail - Year 4'!L60","v":0},{"$f":"'Budget Detail - Year 4'!K60","v":0},{"$f":"'Budget Detail - Year 5'!L60","v":0},{"$f":"'Budget Detail - Year 5'!K60","v":0},19680]
["F. Construction",{"$f":"'Budget Detail - Year 1'!L105","v":0},{"$f":"'Budget Detail - Year 1'!K105","v":0},{"$f":"'Budget Detail - Year 2'!L95","v":0},{"$f":"'Budget Detail - Year 2'!K95","v":0},{"$f":"'Budget Detail - Year 3'!L93","v":0},{"$f":"'Budget Detail - Year 3'!K93","v":0},{"$f":"'Budget Detail - Year 4'!L72","v":0},{"$f":"'Budget Detail - Year 4'!K72","v":0},{"$f":"'Budget Detail - Year 5'!L72","v":0},{"$f":"'Budget Detail - Year 5'!K72","v":0},0]
["G. Subawards (Subgrants)",{"$f":"'Budget Detail - Year 1'!L116","v":0},{"$f":"'Budget Detail - Year 1'!K116","v":0},{"$f":"'Budget Detail - Year 2'!L106","v":0},{"$f":"'Budget Detail - Year 2'!K106","v":0},{"$f":"'Budget Detail - Year 3'!L104","v":0},{"$f":"'Budget Detail - Year 3'!K104","v":0},{"$f":"'Budget Detail - Year 4'!L84","v":0},{"$f":"'Budget Detail - Year 4'!K84","v":0},{"$f":"'Budget Detail - Year 5'!L84","v":0},{"$f":"'Budget Detail - Year 5'!K84","v":0},0]
["H. Procurement Contracts",{"$f":"'Budget Detail - Year 1'!L141","v":152800},{"$f":"'Budget Detail - Year 1'!K141","v":12000},{"$f":"'Budget Detail - Year 2'!L131","v":104802},{"$f":"'Budget Detail - Year 2'!K131","v":16000},{"$f":"'Budget Detail - Year 3'!L128","v":104800},{"$f":"'Budget Detail - Year 3'!K128","v":16000},{"$f":"'Budget Detail - Year 4'!L105","v":0},{"$f":"'Budget Detail - Year 4'!K105","v":0},{"$f":"'Budget Detail - Year 5'!L105","v":0},{"$f":"'Budget Detail - Year 5'!K105","v":0},406402]
["I. Other",{"$f":"'Budget Detail - Year 1'!L162","v":0},{"$f":"'Budget Detail - Year 1'!K162","v":5400},{"$f":"'Budget Detail - Year 2'!L152","v":0},{"$f":"'Budget Detail - Year 2'!K152","v":5400},{"$f":"'Budget Detail - Year 3'!L149","v":0},{"$f":"'Budget Detail - Year 3'!K149","v":5400},{"$f":"'Budget Detail - Year 4'!L126","v":0},{"$f":"'Budget Detail - Year 4'!K126","v":0},{"$f":"'Budget Detail - Year 5'!L126","v":0},{"$f":"'Budget Detail - Year 5'!K126","v":0},16200]
[]
["Total Direct Costs",{"$f":"SUM(B8:B16)","v":310320},97618,268636,94990,264494,98758,0,0,0,0,{"$f":"SUM(B18:K18)","v":1134816}]
["J. Indirect Costs",{"$f":"'Budget Detail - Year 1'!L174","v":8686},{"$f":"'Budget Detail - Year 1'!K174","v":0},{"$f":"'Budget Detail - Year 2'!L164","v":8686},{"$f":"'Budget Detail - Year 2'!K164","v":0},{"$f":"'Budget Detail - Year 3'!L161","v":8686},{"$f":"'Budget Detail - Year 3'!K161","v":0},{"$f":"'Budget Detail - Year 4'!L138","v":0},{"$f":"'Budget Detail - Year 4'!K138","v":0},{"$f":"'Budget Detail - Year 5'!L138","v":0},{"$f":"'Budget Detail - Year 5'!K138","v":0},{"$f":"SUM(B19:K19)","v":26058}]
[]
["Total Project Costs",{"$f":"SUM(B18,B19)","v":319006},97618,{"$f":"SUM(D18,D19)","v":277322},94990,273180,98758,0,0,0,0,{"$f":"SUM(B21:K21)","v":1160874}]
["Does this budget contain conference costs which is defined broadly to include meetings, retreats, seminars, symposia, and training activities? - Y/N",null,null,null,null,null,null,null,null,{"$f":"IF(OR('Budget Detail - Year 1'!K2=\"Yes\",'Budget Detail - Year 2'!K2=\"Yes\",'Budget Detail - Year 3'!K2=\"Yes\",'Budget Detail - Year 4'!K2=\"Yes\",'Budget Detail - Year 5'!K2=\"Yes\"),\"Yes\",\"No\")","v":"Yes"}]

{"sheet":"Admin","index":8,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["devuser1"]

{"sheet":"Reference Data","index":9,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[{"$f":"19760","v":19760},{"$f":"A1*0.9","v":17784},{"$f":"A1*0.1","v":1976}]
[]
[]
[]
[]
["PA1 Equipment Dropdown Options"]
["Vehicles"]
["Vehicles w/ accessory package"]
["Radios"]
["Computers"]
["Computer Aided Dispatch"]
["Records Management System"]
["Communication System"]
["Basic Issue Firearm"]
["Basic Issue Equipment"]
["Bullet Proof Vests"]
[]
["PA1 Supplies Dropdown Options"]
["Basic Issue Uniforms"]
[]
["PA1 Personnel Options"]
["Entry Level Sworn Officer"]
["Village Public Safety Officer (AK Only)"]
["Entry Level Sworn Ranger"]
["Entry Level Sworn Conservation and Wildlife Officer"]
["Civilian Methamphetamine Coordinator"]
[]
["Demographics Yes No Options"]
["Yes"]
["No"]
[]
["Travel Items"]
["Lodging"]
["Meals"]
["Mileage"]
["Transportation"]
["Local Travel"]
["Other"]

{"sheet":"Example - Budget Detail Sheet","index":10,"n_rows":163,"n_cols":12,"rows_kept":163,"cut":false,"hidden":false,"merged":[[6,0,7,1],[6,2,7,3],[6,4,7,4],[6,5,7,6],[6,7,7,8],[6,9,7,9],[0,0,0,5],[0,7,0,11],[4,2,4,11],[5,2,5,11],[6,10,7,10],[6,11,7,11],[1,10,2,11],[1,0,1,9],[2,0,2,1],[8,2,8,3],[8,5,8,6],[8,7,8,8],[12,2,12,3],[12,5,12,6],[12,7,12,8],[9,2,9,3],[9,5,9,6],[9,7,9,8],[28,0,28,8],[30,0,31,11],[33,1,33,2],[33,5,33,11],[34,1,34,2],[34,5,34,11],[23,0,23,2],[23,3,23,4],[23,5,23,8],[27,0,27,2],[27,3,27,4],[27,5,27,8],[26,0,26,2],[26,3,26,4],[26,5,26,8],[25,0,25,2],[25,3,25,4],[25,5,25,8],[24,0,24,2],[24,3,24,4],[24,5,24,8],[35,10,36,10],[35,11,36,11],[37,1,37,2],[51,1,51,2],[52,0,52,8],[54,0,55,11],[48,1,48,2],[47,1,47,2],[46,1,46,2],[45,1,45,2],[35,0,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,7],[35,8,36,8],[35,9,36,9],[38,1,38,2],[44,1,44,2],[43,1,43,2],[42,1,42,2],[41,1,41,2],[40,1,40,2],[39,1,39,2],[63,5,63,8],[57,0,57,2],[57,3,57,11],[58,0,58,2],[58,3,58,11],[59,0,60,2],[59,3,60,4],[59,5,60,8],[59,9,60,9],[59,10,60,10],[59,11,60,11],[62,0,62,2],[62,3,62,4],[62,5,62,8],[61,0,61,2],[61,3,61,4],[61,5,61,8],[63,0,63,1],[63,3,63,4],[71,9,72,9],[71,10,72,10],[71,11,72,11],[64,0,64,8],[66,0,67,11],[69,0,69,2],[69,3,69,11],[70,0,70,2],[70,3,70,11],[78,0,78,1],[78,3,78,4],[78,5,78,8],[75,0,75,2],[75,3,75,4],[75,5,75,8],[74,0,74,2],[71,0,72,2],[71,3,72,4],[71,5,72,8],[77,0,77,2],[77,3,77,4],[77,5,77,8],[76,0,76,2],[76,3,76,4],[76,5,76,8],[73,0,73,2],[73,3,73,4],[73,5,73,8],[74,3,74,4],[74,5,74,8],[86,0,87,2],[86,3,87,4],[86,5,87,8],[86,9,87,9],[86,10,87,10],[86,11,87,11],[79,0,79,8],[81,0,82,11],[84,1,84,2],[84,3,84,11],[85,1,85,2],[85,3,85,11],[83,1,83,11],[89,0,89,8],[91,0,92,11],[93,0,93,1],[94,0,94,1],[94,9,95,11],[95,0,95,1],[88,1,88,2],[88,3,88,4],[88,5,88,8],[94,2,94,6],[95,2,95,6],[94,7,94,8],[95,7,95,8],[101,0,101,8],[112,0,113,11],[114,0,114,1],[115,0,115,1],[116,0,116,1],[96,9,97,9],[96,10,97,10],[96,11,97,11],[98,0,98,1],[98,2,98,8],[100,0,100,1],[100,2,100,8],[99,0,99,1],[115,2,115,6],[116,2,116,6],[115,7,115,8],[116,7,116,8],[99,2,99,6],[99,7,99,8],[102,0,102,1],[103,1,103,2],[103,3,103,5],[103,6,103,11],[104,1,104,2],[136,0,136,11],[138,0,138,1],[138,2,138,11],[139,0,139,1],[139,2,139,11],[140,2,141,3],[140,4,141,4],[140,5,141,6],[140,7,141,8],[140,9,141,9],[155,3,156,4],[155,5,156,8],[155,9,156,9],[155,10,156,10],[155,11,156,11],[147,0,147,1],[147,2,147,3],[147,5,147,6],[147,7,147,8],[148,0,148,8],[150,0,151,11],[160,0,160,8],[162,0,163,11],[11,2,11,3],[11,5,11,6],[11,7,11,8],[10,2,10,3],[10,5,10,6],[10,7,10,8],[50,1,50,2],[49,1,49,2],[157,0,157,2],[157,3,157,4],[157,5,157,8],[159,0,159,2],[159,3,159,4],[159,5,159,8],[158,0,158,2],[158,3,158,4],[158,5,158,8],[153,0,153,2],[153,3,153,11],[154,0,154,2],[154,3,154,11],[155,0,156,2],[20,0,20,2],[20,3,20,11],[21,0,22,2],[21,3,22,4],[21,5,22,8],[21,9,22,9],[21,10,22,10],[21,11,22,11],[13,2,13,3],[13,5,13,6],[13,7,13,8],[14,0,14,8],[16,0,17,11],[19,0,19,2],[19,3,19,11],[123,0,123,8],[134,0,135,11],[146,0,146,1],[146,2,146,3],[146,5,146,6],[146,7,146,8],[145,0,145,1],[145,2,145,3],[145,5,145,6],[145,7,145,8],[144,0,144,1],[144,2,144,3],[144,5,144,6],[144,7,144,8],[143,0,143,1],[143,2,143,3],[143,5,143,6],[143,7,143,8],[140,10,141,10],[140,11,141,11],[142,0,142,1],[142,2,142,3],[142,5,142,6],[142,7,142,8],[104,3,104,5],[104,6,104,11],[105,0,106,5],[105,6,106,6],[105,7,106,7],[105,8,106,8],[105,9,106,9],[105,10,106,10],[105,11,106,11],[107,1,107,2],[107,3,107,5],[108,1,108,2],[108,3,108,5],[109,1,109,2],[109,3,109,5],[110,0,110,8],[124,0,124,1],[125,1,125,2],[125,3,125,5],[125,6,125,11],[117,9,118,9],[117,10,118,10],[117,11,118,11],[119,0,119,1],[119,2,119,8],[120,7,120,8],[121,7,121,8],[120,0,120,1],[120,2,120,6],[121,2,121,6],[121,0,121,1],[122,0,122,1],[122,2,122,8],[129,1,129,2],[129,3,129,5],[130,1,130,2],[130,3,130,5],[131,1,131,2],[131,3,131,5],[132,0,132,8],[126,1,126,2],[126,3,126,5],[126,6,126,11],[127,0,128,5],[127,6,128,6],[127,7,128,7],[127,8,128,8],[127,9,128,9],[127,10,128,10],[127,11,128,11]]}
["Budget Detail\nEXAMPLE"]
["Does this budget contain conference costs which is defined broadly to include meetings, retreats, seminars, symposia, and training activities? - Y/N"]
["(DOJ Financial Guide, Section 3.10)"]
["A. Personnel"]
["Name","Position","Computation"]
["List each name, if known.","List each position, if known.","Show annual salary rate & amount of time devoted to the project for each name/position."]
[null,null,"Salary ",null,"Rate","Time Worked\n(# of hours, days, months, years)",null,"Percentage of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C9*F9*H9,1)","v":0},null,{"$f":"IF(J9-K9<0,0,J9-K9)","v":0}]
["John Smith","Executive Director",140000,null,"yearly",1,null,0.05,null,7000,0,7000]
["Jane Doe","Project Manager",90000,null,"yearly",1,null,0.75,null,67500,0,67500]
["Alex Jones","Program Assistant",22,null,"hourly",1040,null,1,null,22880,0,22880]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J14)","v":97380},{"$f":"SUM(K9:K14)","v":0},{"$f":"SUM(L9:L14)","v":97380}]
["Narrative"]
["John Smith, Executive Director, will provide oversight on the entire award providing 5% of this time to the project.\nJane Doe, Project Manager, will manage the project, complete reports, and submit deliverables spending 75% of her time on the project.\nAlex Jones, Program Assistant, will provide the project manager assistance where needed spending 1,040 hours on the project.\n"]
[]
["B. Fringe Benefits"]
["Name",null,null,"Computation"]
["List each grant-supported position receiving fringe benefits.",null,null,"Show the basis for computation."]
[null,null,null,"Base",null,"Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D24*F24,1)","v":0},null,{"$f":"IF(J24-K24<0,0,J24-K24)","v":0}]
["John Smith",null,null,7000,null,0.25,null,null,null,{"$f":"CEILING(D25*F25,1)","v":1750},0,{"$f":"IF(J25-K25<0,0,J25-K25)","v":1750}]
["Jane Doe",null,null,67500,null,0.25,null,null,null,{"$f":"CEILING(D26*F26,1)","v":16875},0,{"$f":"IF(J26-K26<0,0,J26-K26)","v":16875}]
["Alex Jones",null,null,22880,null,0.25,null,null,null,{"$f":"CEILING(D27*F27,1)","v":5720},0,{"$f":"IF(J27-K27<0,0,J27-K27)","v":5720}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D28*F28,1)","v":0},null,{"$f":"IF(J28-K28<0,0,J28-K28)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J24:J28)","v":24345},{"$f":"SUM(K24:K28)","v":0},{"$f":"SUM(L24:L28)","v":24345}]
["Narrative"]
["Our fringe benefits rate is 25% and covers the following items: FICA (7.65%), Worker's comp (1.35%), Health Insurance (11%), Retirement (5%)"]
[]
["C. Travel"]
["Purpose of Travel","Location",null,"Type of Expense","Basis","Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Lodging, Meals, Etc.","Per day, mile, trip, Etc.","Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,"Cost","Quantity","# of Staff","# of Trips","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,{"$f":"IF((D38=\"Lodging\"),\"Night\",IF((D38=\"Meals\"),\"Day\",IF((D38=\"Mileage\"),\"Mile\",IF((D38=\"Transportation\"),\"Round-trip\",\"N/A\"))))","v":"N/A"},null,null,null,null,{"$f":"CEILING(F38*G38*H38*I38,1)","v":0},null,{"$f":"IF(J38-K38<0,0,J38-K38)","v":0}]
["Project Manager Training","Reno, NV",null,"Other","N/A",50,1,1,1,50,0,50]
["Project Manager Training","Reno, NV",null,"Local Travel","N/A",50,1,1,1,50,0,50]
["Project Manager Training","Reno, NV",null,"Transportation","Round-trip",600,1,1,1,600,0,600]
["Project Manager Training","Reno, NV",null,"Mileage","Mile",0.51,100,1,1,51,0,51]
["Project Manager Training","Reno, NV",null,"Meals","Day",51,5.5,1,1,281,0,281]
["Project Manager Training","Reno, NV",null,"Lodging","Night",94,5,1,1,470,0,470]
["Project Manager Field Travel","Various",null,"Mileage","Mile",0.51,250,1,20,2550,0,2550]
["Mandatory Orientation Training","Washington, DC",null,"Local Travel","N/A",25,1,3,1,75,0,75]
["Mandatory Orientation Training","Washington, DC",null,"Other","N/A",50,1,3,1,150,0,150]
["Mandatory Orientation Training","Washington, DC",null,"Transportation","Round-trip",500,1,3,1,1500,0,1500]
["Mandatory Orientation Training","Washington, DC",null,"Mileage","Mile",0.51,100,1,1,51,0,51]
["Mandatory Orientation Training","Washington, DC",null,"Meals","Day",71,3.5,3,1,746,0,746]
["Mandatory Orientation Training","Washington, DC",null,"Lodging","Night",224,3,3,1,2016,0,2016]
[null,null,null,null,"N/A",null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J38:J52)","v":8590},{"$f":"SUM(K38:K52)","v":0},{"$f":"SUM(L38:L52)","v":8590}]
["Narrative"]
["Per award guidelines, key memebers must attend orientation training in Washington, DC.  WE are following our own written travel policy.  Lodging is for 3 nights and meals are budgeted at 3.5 days as the two travel days are computed at .75 days.  Mileage to get to the airport and local travel is for taxi to and from the airport.  Also baggage fees of $50 is $25 each way.\n\nThe project manager will attend trainin in REno, NV.  We are following our own written travel policy.  Lodging is for 5 nights and meals are budgeted at 5.5 days as the two travel days are computed at .75 days.  Mileage to get to the airport and local travel is for taxi to and from the airport.  Also, baggage fees of $50 is for $25 each way.\n\nThe project manager will use her own vehicle to travel to complete field work with the average trip around 250 miles and an anticipated 20 trips."]
[]
["D. Equipment"]
["Item",null,null,"Computation"]
["List and describe each item of equipment that will be purchased",null,null,"Compute the cost (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D62*F62,1)","v":0},null,{"$f":"IF(J62-K62<0,0,J62-K62)","v":0}]
["Dell Laptop Computer",null,null,1,null,2547,null,null,null,{"$f":"CEILING(D63*F63,1)","v":2547},0,{"$f":"IF(J63-K63<0,0,J63-K63)","v":2547}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D64*F64,1)","v":0},null,{"$f":"IF(J64-K64<0,0,J64-K64)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J62:J64)","v":2547},{"$f":"SUM(K62:K64)","v":0},{"$f":"SUM(L62:L64)","v":2547}]
["Narrative"]
["The project manager will need a laptop computer while out in the field and while away at training.  We are following our agency's capitalization policy."]
[]
["E. Supplies"]
["Supply Items",null,null,"Computation"]
["Provide a list of the types of items to be purchased with grant funds.",null,null,"Describe the item and the compute the costs. Computation: The number of each item to be purchased X the cost per item."]
[null,null,null,"# of Items",null,"Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D74*F74,1)","v":0},null,{"$f":"IF(J74-K74<0,0,J74-K74)","v":0}]
["Printer",null,null,1,null,500,null,null,null,500,0,500]
["Locking file cabinet",null,null,2,null,1000,null,null,null,2000,0,2000]
["Flatbed scanner",null,null,1,null,400,null,null,null,400,0,400]
["General office supplies",null,null,12,null,150,null,null,null,1800,0,1800]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J74:J79)","v":4700},{"$f":"SUM(K74:K79)","v":0},{"$f":"SUM(L74:L79)","v":4700}]
["Narrative"]
["The project manager will need a printer to print reports.  A locking file cabinet is needed to keep client information secure. A flatbed scanner is needed to scan various documents collected in the field.  General office supplies will be used bt all personnel on this project and include: pens, pencils, paper, binder clips, and other basic supplies.  The office supplies are based on 12 months at $150 per month.  This amount was determined based upon other projects of this size that we have completed in the past."]
[]
["F. Construction","As a rule, construction costs are not allowable. Consult with the program office before budgeting funds in this category."]
["Purpose","Description of Work",null,"Computation"]
["Provide the purpose of the construction","Describe the construction project(s)",null,"Compute the costs (e.g., the number of each item to be purchased X the cost per item)"]
[null,null,null,"# of Items",null,"Cost",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D89*F89,1)","v":0},null,{"$f":"IF(J89-K89<0,0,J89-K89)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J89:J89)","v":0},{"$f":"SUM(K89:K89)","v":0},{"$f":"SUM(L89:L89)","v":0}]
["Narrative"]
[]
[]
["G. Subawards (Subgrants)"]
["Description",null,"Purpose",null,null,null,null,"Consultant"]
["Provide a description of the activities to be carried out by subrecipients.",null,"Describe the purpose of the subaward (subgrant)",null,null,null,null,"Is the subaward for a consultant?"]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J99-K99<0,0,J99-K99)","v":0}]
["Conduct field activities in a remote area",null,"Provide services and conduct field work in a remote area included in the project",null,null,null,null,"No",null,25000,0,{"$f":"IF(J100-K100<0,0,J100-K100)","v":25000}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J101-K101<0,0,J101-K101)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J99:J101)","v":25000},{"$f":"SUM(K99:K101)","v":0},{"$f":"SUM(L99:L101)","v":25000}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G108*H108*I108,1)","v":0},null,{"$f":"IF(J108-K108<0,0,J108-K108)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G109*H109*I109,1)","v":0},null,{"$f":"IF(J109-K109<0,0,J109-K109)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G110*H110*I110,1)","v":0},null,{"$f":"IF(J110-K110<0,0,J110-K110)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J108:J110)","v":0},{"$f":"SUM(K108:K110)","v":0},{"$f":"SUM(L108:L110)","v":0}]
["Narrative"]
["The agency will make a subaward to provide services and conduct field work in a remote area.  The $25,000 was calculated based upon a similar size project completed in the same area."]
[]
["H. Procurement Contracts"]
["Description",null,"Purpose",null,null,null,null,"Consultant"]
["Provide a description of the products or services to be procured by contract and an estimate of the costs.  Applicants are encouraged to promote free and open competition in awarding contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold (currently $150,000). ",null,"Describe the purpose of the contract",null,null,null,null,"Is the contract for a consultant?"]
[null,null,null,null,null,null,null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J120-K120<0,0,J120-K120)","v":0}]
["William Penn, CPA",null,"Accounting Assistance",null,null,null,null,"Yes",null,9400,0,{"$f":"IF(J121-K121<0,0,J121-K121)","v":9400}]
["ABC Company",null,"Survey creation and data entry services from submitted surveys.",null,null,null,null,"No",null,40000,0,{"$f":"IF(J122-K122<0,0,J122-K122)","v":40000}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J123-K123<0,0,J123-K123)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J120:J123)","v":49400},{"$f":"SUM(K120:K123)","v":0},{"$f":"SUM(L120:L123)","v":49400}]
["Consultant Travel (if necessary)"]
["Purpose of Travel","Location",null,"Type of Expense",null,null,"Computation"]
["Indicate the purpose of each trip or type of trip (training, advisory group meeting)","Indicate the travel destination.",null,"Hotel, airfare, per diem",null,null,"Compute the cost of each type of expense X the number of people traveling."]
[null,null,null,null,null,null,"Cost","Duration or Distance","# of Staff","Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G130*H130*I130,1)","v":0},null,{"$f":"IF(J130-K130<0,0,J130-K130)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G131*H131*I131,1)","v":0},null,{"$f":"IF(J131-K131<0,0,J131-K131)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(G132*H132*I132,1)","v":0},null,{"$f":"IF(J132-K132<0,0,J132-K132)","v":0}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUM(J130:J132)","v":0},{"$f":"SUM(K130:K132)","v":0},{"$f":"SUM(L130:L132)","v":0}]
["Narrative"]
["ABC Company will put together online an online survey at the direction of the project manager to reach out to the various sites to determine the needs.  In addition a hard copy survey will also be available for thos unable to use the online survey.  ABC Company will key in the hard copy surveys.  Once the surveys are completed, ABC Company will compile the data for the project manager.\n\nWilliam Penn will assist in completing financial reports as well as tracking award expenditures.  Mr. Penn's rate is $47 per hour, and we estimate that Mr. Penn will provide 200 hours of services."]
[]
[]
["I. Other Costs"]
["Description ",null,"Computation"]
["List and describe items that will be paid with grants funds (e.g. rent, reproduction, telephone, janitorial, or security services, and investigative or confidential funds).",null,"Show the basis for computation"]
[null,null,"Quantity",null,"Basis","Cost",null,"Length of Time",null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(C143*F143*H143,1)","v":0},null,{"$f":"IF(J143-K143<0,0,J143-K143)","v":0}]
["Rent",null,500,null,"sq feet",2.5099999999999998,null,12,null,15060,0,15060]
["Telephone",null,1,null,"monthly rate",50,null,12,null,600,0,600]
["Reproduction",null,500,null,"per copy",0.05,null,12,null,300,0,300]
["Postage",null,1000,null,"quarterly newsletter",0.5,null,4,null,2000,0,2000]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J144:J148)","v":17960},{"$f":"SUM(K148:K148)","v":0},{"$f":"SUM(L144:L148)","v":17960}]
["Narrative"]
["Rent is charged at $2.51 per square foot per month.\nTelephone is based upon $50 per month for 12 months.\nReproduction is based on 500 copies per month for 12 moths.\nPostage for mailing a quarterly newsletter for 1,000 recipients."]
[]
["J. Indirect Costs"]
["Description",null,null,"Computation"]
["Describe what the approved rate is and how it is applied.",null,null,"Compute the indirect costs for those portions of the program which allow such costs."]
[null,null,null,"Base",null,"Indirect Cost Rate",null,null,null,"Total Cost","Non-Federal Contribution","Federal Request"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D158*F158,1)","v":0},null,{"$f":"IF(J158-K158<0,0,J158-K158)","v":0}]
["Indirect Costs",null,null,121725,null,0.12540000000000001,null,null,null,{"$f":"CEILING(D159*F159,1)","v":15265},0,{"$f":"IF(J159-K159<0,0,J159-K159)","v":15265}]
[null,null,null,null,null,null,null,null,null,{"$f":"CEILING(D160*F160,1)","v":0},null,{"$f":"IF(J160-K160<0,0,J160-K160)","v":0}]
["Total(s)",null,null,null,null,null,null,null,null,{"$f":"SUM(J158:J160)","v":15265},{"$f":"SUM(K158:K160)","v":0},{"$f":"SUM(L158:L160)","v":15265}]
["Narrative"]
["Indirect costs are based on Federally approved rate of 12.54% on Total Direct Labor (Personnel + Fringe)."]

{"sheet":"Definitions","index":11,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["Definitions"]
["Additional information can be found in the DOJ Financial Guide"]
["DOJ Financial Guide"]
["Term","Definition"]
["Match","Match is the recipient share of the project costs. Match may either be “in-kind” or “cash.” In-kind match includes the value of donated services. Cash match includes actual cash spent by the recipient and must have a cost relationship to the Federal award that is being matched. (Example: Match on administrative costs should be other administrative costs, not other matching on\nprogram costs). \n\nSample Non-Federal Match Calculation:\nMatch Calculation: If the match is 25%, the calculation is as follows:\nFederal Request:  $350,000\nDivided by .75 or 75%:  $466,667\nMultiplied by match amount .25 or 25%\nequal required match amount:  $116,667"]
["Approved Negotiated Rate","Approved Negotiated Rate is any current fringe benefits rate approved for the grant recipient by their cognizant Federal agency."]
["Expendable","An expendable item is any materials that are consumed during the course of the project such as office supplies, program supplies etc. Expendable items are usually considered to be consumed when issued and are not recorded as returnable inventory. "]
["Non-Expendable","A non-expendable item is tangible property having a useful life of more than two years and an acquisition cost of $5,000 or more per unit. (Note: Organization’s own capitalization policy may be used for items costing less than $5,000). "]
["Renovations","Costs incurred for ordinary rearrangements, alterations and restoration of facilities are considered allowable. Special arrangement and alteration costs incurred specifically for the project are allowable with the prior approval of the awarding agency."]
["Federal Acquisition Regulations","The Federal Acquisition Regulations are established for the codification and publication of uniform policies and procedures for acquisition by all executive agencies. The Federal Acquisition Regulations System consists of the Federal Acquisition Regulation (FAR), which is the primary document, and agency acquisition regulations that implement or supplement the FAR."]
["Sole Source","Procurement by noncompetitive proposals is procurement through the solicitation from only one source, or after solicitation of a number of sources, competition is determined inadequate.\n\nGrant recipients may make the initial determination that competition is not feasible if one of the following circumstances exists:\n1. The item of service is available only from a single source.\n2. The public exigency or emergency for the requirement will not permit a delay resulting from a competitive solicitation.\n3. After solicitation of a number of sources, competitions is considered inadequate."]
["Arm-Length Transaction","A transaction in which the buyers and sellers of a product act independently and have no relationship to each other. The concept of an arm's length transaction is to ensure that both parties in the deal are acting in their own self interest and are not subject to any pressure or duress from the other party.\n\nGenerally, costs of renting facilities are not allowable where one party to the rental agreement is able to control or substantially influence the actions of the other (e.g. organizations under common control through common officers. Directors or members)."]
["Confidential Funds","Confidential funds are those monies allocated to:\n\nPurchase of Services (P/S).\nThis category includes travel or transportation of a non- Federal officer or an informant; the lease of an apartment, business front, luxury-type automobiles, aircraft or boat, or similar effects to create or establish the appearance of affluence; and/or meals, beverages, entertainment, and similar expenses (including buy money and flash rolls, etc.) for undercover purposes, within reasonable limits.\n\nPurchase of Evidence (P/E).\nThis category is for P/E and/or contraband, such as narcotics and dangerous drugs, firearms, stolen property, counterfeit tax stamps, and so forth, required to determine the existence of a crime or to establish the identity of a participant in a crime.\n\nPurchase of Specific Information (P/I).\nThis category includes the payment of monies to an informant for specific information. All other informant expenses would be classified under P/S and charged accordingly. "]
["Fully Executed Negotiated Agreement","Fully Executed Negotiated Agreement is a signed, approved indirect cost rate agreement which reflects an understanding reached between the grant recipient and the cognizant Federal agency."]
["Cognizant Federal Agency","The cognizant Federal agency is the Federal agency that generally provides the most Federal financial assistance to t he recipient of funds. Cognizance is assigned by the Office of Management and Budget (OMB). Cognizant agency assignments for the largest cities and counties are published in the Federal Register."]